Running dtsrun through a store procedure

[qaddba]

Hi,

I have a simple dts on a server. Same server i am trying to create a store procedure and using xp_cmdshell to run the dtsrun.

The dts run is running fine when i run through the dos but it fails when i run through query analyzer sql.

Please advice.
Thanks,
Quadeer

 

[MissTipps]

Hi

When you attempt to run it in Query analyzer, what error do you receive?



MissTipps

CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+