dts script - ActiveX task to call transform data

[bigfoot]

I'm working on a DTS package where I'm using FileSystemObject in an ActiveX script.

I have a Transform Data Package that I'd like to "call" from the ActiveX script, one time for every loop.

Here's my logic:
1. Get the folder.
2. Read through all the files.
3. For every file, set a global var to the file name.
4.Run the Transformation script that uses the global var to read the file and put the data into the database.
5. Get the next file.

Any way to call the task in the same dts package from a script in the same package?

Any help would be really great. Thanks..

 

[AlexCuse]

I think this will be a good read for you:

http://www.sqldts.com/246.aspx

Hope this helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[bigfoot]

Thank you Alex, but that is how it's working, or not working now.
The server is so slow, I think it's timing out.
It seems to work great on my test system, but when moving it to production, it fails on more then 1 file.
It takes around 9 seconds to get a hold of the text file.

It's not my server so I can't do much. A co-worker came up with a better plan.
Since they are all flat files anyway, he said to just run a dos copy command and consolidate them all into 1 file, (copy xxxx.* to Pickup.txt) then move the originals to archive.
Next read the one file, then on success, delete it.

I'm going to try this approach this morning.