Jul
6
2011

Identify which DTS package is being called by scheduled job!

I was struggling to identify the DTS package name from the job syntax which looks like,

DTSRun /~Z0x5B431B25562BD74…2AE391DF759D0B3B09EEAB94B687E05E66CE7307C6304204

this can be simulated by right clicking the DTS Package (SQL 2000) and schedule a job. If you schedule a package to run that way, the SQL Job it creates will have an encrypted name for DTS package in SQL job step – similar to what you see above.

Found a solution to this at following link

To avoid this, you can simply create a SQL Job and choose CmdExec as a step type and type following in your step:

DTSRun /N”your package name” /S < servername > /E < for trusted connection >

OR

DTSRun /N”Your package Name” /S < ServerName > /U < UserName > /P < Password > — for SQL authentication

This way we can have meaningful package name in the job. But in case for some reason, you do have those Jobs with weird encrypted DTS package name, here is how you can identify which package is being called by that step (this is something I found from SQL Forum):

1. Copy the DTSRUN line (everything including the DTSRUN)
2. Open a Windows Command Line window
3. Paste the DTSRUN line into the CMD window.
4. To the end of the line, add /!X /!C
/!X = do not execute /!C = copy results onto Windows Clipboard
5. Run the command
6. Open Notepad
7. Click Edit>Paste

that will paste the actual command into Notepad and it will show the name of the package.

Hope, above will solve issue if you have come across such situation.

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 254 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2020
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: