Good afternoon all,
This is what I want to do:
1. Drop indexes from a table.
2. Append a variable number of text files to the table.
3. Rebuild the indexes on the table.
The text files are all in the same directory on the network and they are the only files in the directory.
Since the data has to be transformed a bit, I think that I need to use a DTS package. Or maybe I can just get the code of the DTS package? From where?
The parameter that I want to send to the DTS package or whatever is the file name. I don't know the name beforehand or the number of files.
So I am thinking of a stored procedure that gets each file name and then passes it to a DTS package.
I would appreciate any input on the best way to accomplish this.
I am a experienced VB, VBA, and ColdFusion programmer and I am getting pretty good at SQL,so I'm not a total newbie.
Thanks for any help. Kathryn
This is what I want to do:
1. Drop indexes from a table.
2. Append a variable number of text files to the table.
3. Rebuild the indexes on the table.
The text files are all in the same directory on the network and they are the only files in the directory.
Since the data has to be transformed a bit, I think that I need to use a DTS package. Or maybe I can just get the code of the DTS package? From where?
The parameter that I want to send to the DTS package or whatever is the file name. I don't know the name beforehand or the number of files.
So I am thinking of a stored procedure that gets each file name and then passes it to a DTS package.
I would appreciate any input on the best way to accomplish this.
I am a experienced VB, VBA, and ColdFusion programmer and I am getting pretty good at SQL,so I'm not a total newbie.
Thanks for any help. Kathryn