Execute DTS from SP

[ScrewBalll]

Hi there,
Just a quick question: Is there any way that you can execute a DTS package from a stored procedure? I'm pretty sure you can't but I just want to check to make sure.
Thanks

 

[JamesLean]

Yes. You can use xp_cmdshell to execute the DTSRun utility, eg:

EXEC master..xp_cmdshell 'dtsrun /S myserver /E /N "my package name"'

--James

 

[ScrewBalll]

Ah brilliant, thanks