Need to programmatically edit dts package and run it

[kathryn]

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

 

[tlbroadbent]

Check these pages. You should be able to find info that will help you accomplish your task.

Import all files in a directory (Multi Pkg)

http://www.swynk.com/friends/green/dtsdirlooppkg.asp

Import all files in a directory (Multi Step)

http://www.swynk.com/friends/green/dtsdirloopstep.asp

Global Variables and Stored Procedure Output Parameters

http://www.sqldts.com/main.asp?nav=1,6,234,0

How can I change the source data file for a Bulk Insert Task

http://www.sqldts.com/main.asp?nav=1,6,231,0

How can I check if a file exists?

http://www.sqldts.com/main.asp?nav=1,6,211,0

Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm