Add a DTS to an existing SQL Server Agent Job
-
Guys hi,
i am new to administration and would like to know how can i add a DTS package to an existing SQL Server Agent Job.
I have 2 dts packages that need to put under the same Job. So to create the job, I go to the first DTS package, right clikck on it, and then choose Schedule, etc.
The i go to SQL Server Agent, choose the package i just created, i go to steps and I want to add a second step with another DTS package. So i press new and i choose Operating System Command CMDExec. My question is,
What do i write in the box Command, in order to add another DTS a second Job step?
When i look in another packages to see the syntax, all i see is incomprehensible values like
DTSRun /~Z0x170739B3D4AB....
Which i can make no sense..
Somebody help? lol???
-
what you see is the encrypted hexadecimal text representing the packagename
you can add another jobstep cmdexec-type with
dtsrun.exe /N package_name
you can find more info in books online (search dtsrun)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
An easy way to generate a DTSRUN command is to use the dtsrunui utility. You can find instructions for it's use in BooksOnLine, but basically you run it from a command prompt, choose the server and package, click on the "Advanced" button and click the "Generate" button. You can specify whether or not you want the command encrypted. Copy and past the resulting command into a job step in an existing job.
Greg
Greg
-
You could also use Enterprise Manager...
1. Right-click on your package in the Data Transformation Services > Local Packages and choose to schedule it.
2. Set up a dummy schedule for your package, details don't matter too much.
3. Find your scheduled job in Management > Sql Server Agent > Jobs and edit the properties
4. On the Steps tab, edit the job step for the DTS package run.
5. Copy the Command code from this job in to your other job
6. Delete the dummy package job.
It's a long way but ensures that your package is included in the same way the others are.
Good luck!
Ade
-
Thank you all for your answers.
That is why i love this forum, cause people answer to your requests.
Regarding Adrian Nicjhols reply, thank you mate, that was the solution i had allready thought of.
But i wanted the proper solution as this seem to be a "correct" but anorthodox way. Thank you again for your reply. The most proper answer seems to me alzdba's answer, although thank you all once again for your promptly replies.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply