How to add a DTS Package as one step to a job manually?

Question

Post reply

How to add a DTS Package as one step to a job manually?

Kent Zhou

Right there with Babe

Points: 731
More actions
May 4, 2009 at 8:35 am

#133770

When scheduling a DTS package, the command for the step is created as encrypt hex like:
DTSRun /~Z0xD4C42747D72208F35ADE9....
But If I want to add a step to a job manually, the wizard will ask for following setting:
Type: Operating System Command(CmdExec)
Process exis code of a successful command:0
Command:
How to set DTSRUN param for the command? should be like following?
DTSRun "DTS Package Name"

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55548 More actions · Answer 1

DTSRun /S ServerName /E /N"PackageName"

see: http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx

Kent Zhou Right there with Babe Points: 731 More actions · Answer 2

Thanks.

On SQL server 2008, I run the dts package Test in command line as below and succeeded.

dtsrun /S myServer\Myinstance /E /N Test

Then I create a job and set command as above for the step. and then run the job, it failed!

The error message is:

Message

Executed as user: MyDomain\sqlservice. The process could not be created for step 1 of job 0xACCD42B421607047A3F07F1411A9DC1F (reason: The system cannot find the file specified). The step failed.

The message is confusing. The DTS is save in msdb and should not look for a file for it!

What's the reason and how to resolve it?

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

The encrypted command needs to be changed because the package is in a new instance. See my reply to your post in the SQL Agent forum (http://www.sqlservercentral.com/Forums/Topic708454-110-1.aspx#bm709515) to see how to regenerate the encrypted command or use Homebrew's suggestion and format the command without encrypting it.

Greg

Kent Zhou Right there with Babe Points: 731 More actions · Answer 4

So there two ways: one is plain text, one is encrypt:

dtsrun /S myServer\Myinstance /E /N Test

DTSRun /~Z0xB9A94C2AA29A29C9B....

I can run both of them in MS-DOS command line and success.

But if I put them for steps for job in command box and then run the job, it failed.

Same error message as:

Message

Executed as user: myDomain\sqlservice. The process could not be created for step 1 of job 0x811094B3EEFE7F4C8BB0F0584FFD3A19 (reason: The system cannot find the file specified). The step failed.