Launch DTS Asynchrously from VB / Get status from DTS 1

[tomatdeepwater]

Hi! DTS is new for me.

I have a rather long running DTS package that I launch from VB/VBA. I want to be able to do 2 things:

-- Launch the package and have it proceed asynchronously
(ie. NOT wait until the DTS package completes)

-- Get information back from the DTS package as to its
status. There are a number of looping steps. It would
be nice to determine from my UI what step it is on AND
what row it is currently processing in that step.

Is this possible?

 

[earthandfire]

The following is for VB.NET. There is also a similar article for VB 6 but I can't find it at the moment.

http://support.microsoft.com/?kbid=321525

Hope this helps.