How to figure out what a DTSRun command is doing 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?
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&lt;servername&gt; /E   --- for trusted connection


OR

DTSRun /N"Your package Name" /S&lt;ServerName&gt; /U&lt;UserName&gt; /P&lt;Password&gt;   --- 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 : 


How to identify which DTS Package is being called by scheduled job 
dtsrun Utility