Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have taken over a SQL 2000 database. I am trying to figure out what a job is doing. Its command is:

DTSRun /~....a big hex string....

I have tried to run:

DTSRun /~....a big hex string.... /!Y

to see what it is doing, but it just repeats the command. Is there a way I can see what this string represents?

share|improve this question
up vote 6 down vote accepted

You ave to use /!X /!C after the DTS command.

/!X ==> Do not run the package

/!C ==> copy the results to clipboard

To avoid this, you can create a SQL Agent Job and choose CmdExec as a step type with below commandline:

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


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

As a sidenote, its time for migration to something supported by Microsoft sql 2005, sql 2008 R2 or 2012 along with migrating DTS packages to SSIS.

Refer to :

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.