Hello,

I have DTS packages being run within a VB client through
the DTS object library, and would like to run the
packages in an asynch fashion if possible. At present,
once a package is executed, the rest of the machine is
blocked until that package finishes. Is there any way to
prevent this blocking behavior when executing packages
through library?

Any help much appreciated.

Thanks,

Greg Hayes

In article <012f01c340ca$32eed430$a501280a (AT) phx (DOT) gbl>, Greg Hayes
<gjhayes (AT) attglobal (DOT) net> writes
You could use dtsrun and (and maybe start) but the package will still be
executing on your machine. DTS is COM, so it is client side, is this
what you want, the package running on your machine?

Using events through VB will give you more interaction.
http://support.microsoft.com/?kbid=221193
Execute a package from Visual Basic (VB)
http://www.sqldts.com/default.aspx?6,104,208,7,1


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com