Running a DTS package from a stored procedure?

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_oacre...DTSpackage.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!
>sql