dts fired from sp

Hello,
Is it possible to fire a DTS from within a stored procedure?
tia,
bob mcclellanIf you know the command line to pass to dtsrun, and you can use xp_cmdshell,
then sure:
exec master..xp_cmdshell 'dtsrun.exe ... '
"John 3:16" <bobmcc@.tricoequipment.com> wrote in message
news:u2uNrUY4FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is it possible to fire a DTS from within a stored procedure?
> tia,
> bob mcclellan
>|||Select 'You''re fired' from table where job = 'DTS'
Ok, I know. It's lame but I have my reasons..
It's Friday, I'm tired, I can't wait to get home and my first grandson was
born yesterday.
"John 3:16" <bobmcc@.tricoequipment.com> wrote in message
news:u2uNrUY4FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is it possible to fire a DTS from within a stored procedure?
> tia,
> bob mcclellan
>|||Great.
I just needed a place to start in BOL.
Thanks much Aaron.
bob.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23mYIbYY4FHA.1396@.TK2MSFTNGP12.phx.gbl...
> If you know the command line to pass to dtsrun, and you can use
> xp_cmdshell, then sure:
> exec master..xp_cmdshell 'dtsrun.exe ... '
>
>
> "John 3:16" <bobmcc@.tricoequipment.com> wrote in message
> news:u2uNrUY4FHA.2552@.TK2MSFTNGP10.phx.gbl...
>|||Congrats Ray.
Enjoy the wend with your new grandson.
"Raymond D'Anjou" <rdanjou@.canatradeNOSPAM.com> wrote in message
news:eY3hVaY4FHA.700@.TK2MSFTNGP15.phx.gbl...
> Select 'You''re fired' from table where job = 'DTS'
> Ok, I know. It's lame but I have my reasons..
> It's Friday, I'm tired, I can't wait to get home and my first grandson was
> born yesterday.
> "John 3:16" <bobmcc@.tricoequipment.com> wrote in message
> news:u2uNrUY4FHA.2552@.TK2MSFTNGP10.phx.gbl...
>