Hello,
I need to transfer 312 files into as many tables in an SQL 2000 database.
Each file is a set of lines with a semi-colon separated columns, and have to be transferred in a table named after the file.
Each file have a different number of fields, each resulting in a table column.
I build a sample DTS package which works fine for a file (reading the file and creating the table).
How can I get a generic DTS package ?
The trick is that when run the DTS asks for a description of the "transform data task" just to be told that it is the simplest way : each column from a file field.
And I didn't found a way to do this automatically.
Thank you for any clue.
I need to transfer 312 files into as many tables in an SQL 2000 database.
Each file is a set of lines with a semi-colon separated columns, and have to be transferred in a table named after the file.
Each file have a different number of fields, each resulting in a table column.
I build a sample DTS package which works fine for a file (reading the file and creating the table).
How can I get a generic DTS package ?
The trick is that when run the DTS asks for a description of the "transform data task" just to be told that it is the simplest way : each column from a file field.
And I didn't found a way to do this automatically.
Thank you for any clue.