Executing dts from stored procedure

[tbailey922]

Hello,
Does anybody know to execute a dts package from a stored procedure. Or maybe tell me why I am getting this error. From QA I execute: exec master..xp_cmdshell 'DTSRun /S "INTRANET" /U "test" /P "bailey33" /N "exporttoexcel" /V "{E60BEDE0-654A-489A-B755-9835D221A100}" '

I get the following errors:
DTSRun: Loading...
DTSRun: Executing...

Error: -2147220499 (800403ED); Provider Error: 0 (0)
Error string: No Steps have been defined for the transformation Package.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 700


thanks
Tim

 

[mrdenny]

It sounds like the version of the package you are trying to run has no steps. Instead of using the /V switch (which is the GUID for a specific version of the package) use the /N switch which is the switch for the name of the package.

Denny

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

 

[tbailey922]

I still the same error. Still dazed and confused!

 

[mrdenny]

Can you run the package from within Enterprise Manager with out any problems?

Now that I look at your command string again, I see that you already have the /N switch, so just remove the /V switch.

Denny

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