I
INTP56
I have many users that store their data in different ways. I am trying to
develop an overall system to get that data into a database.
What I would like to do is to put the (Full UNC) filepath into a database
table, that IntegrationServices could use later to actually import the file.
I often find there in information in the file path itself, as well as
information that only exists in the users head. I would like to use InfoPath
to collect this information, having the user describe various attributes, and
have a list of files that get inserted into the database.
While I can create a file attachment control,I have to jam that in to one
field, and then parse and process that field into the database. And I seem to
be limited as to what I can put in there. I was hoping to use
IntegrationServices to actually parse and load the data.
Anyone have any ideas how I might accomplish this?
Bob
develop an overall system to get that data into a database.
What I would like to do is to put the (Full UNC) filepath into a database
table, that IntegrationServices could use later to actually import the file.
I often find there in information in the file path itself, as well as
information that only exists in the users head. I would like to use InfoPath
to collect this information, having the user describe various attributes, and
have a list of files that get inserted into the database.
While I can create a file attachment control,I have to jam that in to one
field, and then parse and process that field into the database. And I seem to
be limited as to what I can put in there. I was hoping to use
IntegrationServices to actually parse and load the data.
Anyone have any ideas how I might accomplish this?
Bob