Is it possible to run a DTS package from a stored procedure?
If yes how would I go about doing this?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!You can use dtsrun and xp_cmdshell (probbly the easiest) or you can use the sp_oa SPs - example at
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html
"Rob NA" wrote:
>
>
> Is it possible to run a DTS package from a stored procedure?
> If yes how would I go about doing this?
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment