DTS Run /Z~

[dgillz]

I have walked in to a new customer that has several DTS jobs, and on about a third of them when I look at properties, I see "DTS Run /Z~" followed by a long string of meaningless junk.

How can I translate this into the actual SQL code or stored procedure being run by this job?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mrdenny]

There really isn't an easy way. That string after the /Z is the encrypted value which tells the SQL Server which package to run.

Hopefully when they created the jobs, they didn't rename them. If they didn't, the name of the job will be the same name as the package.

If they did change the job name, the easiest way to see which package is which would be run run the package manually. It should say which package is being run.

You can also check the job history, it might say the package name in the step history.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[dgillz]

I am back on this after a brief hiatus. I see how I can run the package now but how would this tell me the SQL it is actually running? It does show the package name, the same name as my original post, but the underlying SQL could be "Delete from Customers" or something equally malicious.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mutley1]

You would need to go into the actual package and look at what it is doing in each step. If you can work out the package from Mr Denny's sage advice then open it up in designer and just look at each step.

 

[dgillz]

Mutley,

Please read my original post. The actual package- there is only one step - says DTS Run /Z~ followed by a bunch of gobblygook. There is no SQL code here.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[mutley1]

Sorry - I misunderstood. All clear now. So you have tasks within 1 DTS package calling the DTS run for others by the sound of it.

 

[mrdenny]

Correct, when running a DTS package there is no T/SQL code in the job step. The T/SQL code is stored within the DTS package it self. To see what the DTS package is doing you have to edit the DTS package and see exactly what the T/SQL is.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog