Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Run DTS Package from Stored Proc

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-28 : 23:53:02
Dave writes "Can you run a DTS package from a Stored Proc in SQL Server 7?

I've seen many examples of running DTS packages but none from say the Query Analyzer or a Stored Proc. The user guide implies that it can be done by EXECuting it. When I try this I get a "DTS_LoadVendors" stored proc not found. It's of course not found because it's not a SP, it's a DTS package.

An example would be greatly apppreciated.

Thanks
DaveH"
   

- Advertisement -