Problem with trigger running a DTS script

[ChrisBeach]

I have a table with an update trigger, could anyone give me an example of code I could use to run my DTS script, whenever i try

EXEC xp_CMDShell 'DEAL_SalesCond'

it gives me a "no such stored proc as.." so I'm sure I'm going about it wrong, any help greatly appreciated, thanks!

 

[mrdenny]

You need to call xp_cmdshell with it's 3 part name master.dbo.xp_cmdshell. Within xp_cmdshell you'll need to call dtsrun.exe and give it the needed paramaters.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[ChrisBeach]

Thanks =)

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)