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 Administration (2000)
 DTS

Author  Topic 

amex45
Starting Member

16 Posts

Posted - 2002-08-07 : 11:37:47
Is there any way to call a DTS package inside a Stored Proc?

Thanks


jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-08-07 : 12:42:54
check out DTSRUN in BOL

e.g.

exec master..xp_cmdshell 'dtsrun /Sserver_name /E /Npackage_name'

HTH
Jasper Smith
Go to Top of Page
   

- Advertisement -