Running a DTS in Stored Procedure or VB

[netcashin]

I am in need of running a DTS package. Would prefer to run it in a stored procedure but could run it in VB code if necessary.

Any Ideas????

And thanks to FoxDev for helping in setting up a way to transfer from SQL to Excel.

 

[foxdev]

I'm sure Tom or others can provide more solid details, but I believe you can invoke DTSRUN and pass it amessa parameters.

See the topic dtsrun Utility in BOL.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

From a proc, you can invoke DTSRUN to run the package via the shell. One of MANY ways to do this could be to invoke master..xp_cmdshell to fire it off.. There are other ways to do this through DTS's active-x interface as well..

Of course, Roberts recommendation should be followed by all that visit this site: read books-online. It contains invaluable sources of information for many topics discussed in this forum.

Tom

 

[foxdev]

I'm not always a fan of Microsoft products, but I give them their due when they deserve it: SQL Server 7's Books Online is certainly one of the best, if not the best, "in the box" product references I've ever encountered.

With that, plus Delaney's book, and you're pretty much all set.

Robert Bradley

http://www.foxdev.com/