DTS Execution

[RobS23]

I'm having a hard time getting a DTS package to execute from within a Stored Procedure. I've been following the books online examples but something is wrong.

Hope you can help!

Here's the details

Server name = LapServer
Db name = dbMIS
DTS package = dtsEDIImport

Db uses NT security so there should be no need for the password fields

Surely - EXEC xp_cmdshell 'dtsrun /SLapserver/dtsEDIImport'

- should be working?

 

[rajeevnandanmishra]

Hi RobS23,
Please let us know the error message/ error no. you are getting.

 

[RobS23]

I'm not getting a specific output message - just the usual output bumpf and the Package name or GUID not provided.