Execute DTS package from a Stored Procedure 1

[vituja]

Hi All,

Can a DTS package be executed from a stored procedure? If so how would I go about writing the SP code to execute the package?

Any help would be appreicated. Thanks.

 

[JamesLean]

You can use xp_cmdshell to execute the dtsrun utility, something like:

EXEC master..xp_cmdshell 'dtsrun /Smyserver /E /Nmypackage'

This runs mypackage on myserver, using a trusted connection. Look up dtsrun in BOL for all info.

--James

 

[JayKusch]

You would do something like this ...


EXEC xp_cmdshell 'dtsrun /S /U /P /N PackageName'


Thanks

J. Kusch