Problem with DTSRUN

[dcusick]

What's up? I have a question about using DTSRun in a SP to execute a DTS Package. Mine doesn't seem to wanna work.
Here is my code to run it...

exec master..xp_cmdshell 'dtsrun /SRSD8334 /Uuser /Ppass /NExecuteLN /AlogID:3=2810'

When I execute my SP, or run it from Query Analyzer, the grid shows the following:

output
DTSRUN: Loading...
NULL

If I execute the Package manually it runs fine. If I put the above command into a Command Prompt and run it, it runs fine. Any idea where I'm going wrong?? Thanks.

Doug

 

[MDXer]

have you tried specifying the path to DTSRun.exe?

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[dcusick]

Yeah, I tried that... Still have the same problem... I tried to run it with OLE Automation using the sp_OA* procedures, but I am still getting nothing! THis is the error I am getting from that...

***  Load Package failed
OLE Automation Error Information
  HRESULT: 0x80040005
  sp_OAGetErrorInfo failed.

Any Ideas??? Thanks.

Doug

 

[JayKusch]

Maybe a permissions issue w/ your global variable AlogID:3=2810 ???

Thanks

J. Kusch

 

[dcusick]

hmm... Two questions about that then JayKusch... First off, how would I set permissions specifically for the Global Variable? And secondly, if that was the case, why would it run from the command prompt, but not from a Stored Procedure? Thanks.

Doug

 

[JayKusch]

Here is a quip from BOL on the /A parameter ...

/A global_variable_name:typeid=value

Specifies a package global variable, where typeid = type identifier for the data type of the global variable. The entire argument string can be quoted. This argument can be repeated to specify multiple global variables. See the Remarks section for the different available type identifiers available with global variables.

To set global variables with this command switch, you must have either Owner permission for the package or the package must have been saved without DTS password protection enabled. If you do not have Owner permission, you can specify global variables, but the values used will be those set in the package, not those specified with the /A command switch.


As for it runnning on the Command Line ... Hmmmm .... Still checking for an answer to that one! LOL


Thanks

J. Kusch

 

[dcusick]

Yeah, I'm actually the owner of the Package, plus I did not set a password for it. But I set the global to a default value, and took that argument out of my call. And I still am getting the same result. DOH! This is starting to bug me... Google has failed me! haha

Doug