dts fired from sp

4 Nov 2005 9:17 PM

John 3:16

Hello,

Is it possible to fire a DTS from within a stored procedure?

tia,
bob mcclellan

4 Nov 2005 9:26 PM

Aaron Bertrand [SQL Server MVP]

If you know the command line to pass to dtsrun, and you can use xp_cmdshell,
then sure:

exec master..xp_cmdshell 'dtsrun.exe ... '

Show quote

"John 3:16" <bob***@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
>

4 Nov 2005 9:29 PM

John 3:16

Great.
I just needed a place to start in BOL.

Thanks much Aaron.

bob.

Show quote

"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" <bob***@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
>>
>
>

4 Nov 2005 9:27 PM

Raymond D'Anjou

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.

Show quote

"John 3:16" <bob***@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
>

4 Nov 2005 9:37 PM

John 3:16

Congrats Ray.
Enjoy the weekend with your new grandson.

Show quote

"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" <bob***@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
>>
>
>