Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Deciphering DTSRun String in Sql Server Agent Job Expand / Collapse
Author
Message
Posted Friday, February 18, 2005 12:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 17, 2005 2:16 PM
Points: 4, Visits: 1

I am trying to bring up our DTS and SQL Server Agent Jobs Sorbox compliant.  I am trying to decipher the DTSRun~/ (Long Numeric String) in each step within each job.  There is no easy way.

I have looked inside msdb but it also has this long numeric string.  Does anyone know how to decipher this long string or where in msdb it exist.  Thanks.

Post #162801
Posted Monday, February 21, 2005 2:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, July 18, 2009 3:04 AM
Points: 16, Visits: 24
I'd like to know this too, as I found this thread when searching for a solution to the exact same problem.
Post #162962
Posted Wednesday, February 23, 2005 10:07 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:07 AM
Points: 434, Visits: 272

In the DTS GUI, the package and version GUIDs are in the package properties dialog box.  You can find the package name in msdb..sysdtspackages like this:

SELECT     name
FROM         sysdtspackages
WHERE     (id = '{55521ACB-1643-45CD-B882-A6AB20FF59F8}') OR
                      (versionid = '{67B35377-A60B-4EC8-A240-184CFD12834E}')

Fields:

name is the package name

id is the package GUID

versionid is the version GUID

If you have the Wrox SQL Server 2000 DTS book, see page 69 to read about the switches.



ZenDada
Post #163546
Posted Wednesday, February 23, 2005 12:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 17, 2005 2:16 PM
Points: 4, Visits: 1

Thanks Jules.

I have gone through this process and able to look at the GUIID and Version ID. I am needing to decipher the DTS RUN Cmd inside the Server Agent - Jobs. 

There is a tool that I am trying to use - DecDTSRun.c.  It is written in C and I do not have much experience in C.  Are you familiar with this tool.

Ernest

Post #163567
Posted Thursday, February 24, 2005 9:40 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:07 AM
Points: 434, Visits: 272

No, sorry, not familiar with the tool. 

Do you simply need to query sysjobsteps?  The command field has the dts run command in it.



ZenDada
Post #163808
Posted Thursday, February 24, 2005 11:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 17, 2005 2:16 PM
Points: 4, Visits: 1

I am needing to decrypt the string (DTSPackage) after the dtsrun command so that I am able to see which package is attached to each job.  Sort of...reverse engineer.  My other alternative is to recreate the jobs; however, this process is much to tediuos.

Up to this point, I haven't found a method to decrypt this string.

Ernest

Post #163838
Posted Thursday, February 24, 2005 2:37 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:07 AM
Points: 434, Visits: 272

In the future, when you schedule a dts package as a job - say using dtsrunui, simply don't check "encrypt" when you generate the command string.  Or create the string manually in EM.  Don't right click on the package to schedule - that always creates an encrypted command string.  If that is the reason that you have encrypted command strings in the first place, then you may be in luck - because the name of the dts package being executed will be in the name field of sysjobsteps unless someone manually changed the name of the step.  But that's a pretty big leap of faith. I don't think you should be able to decrypt the string once encrypted.  I guess that's kind of the point, eh?  Given that that is the case, you can't prove that a dtsrun command really does what you say it does unless you re-write it yourself without encryption.  Sure it's a hassle but it's probably the right thing to do.



ZenDada
Post #163902
Posted Friday, March 4, 2005 2:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:46 PM
Points: 19, Visits: 68

You shouldn't be able to, but you can...

Of course compiling C programs will drive a non-c programmer crazy.  They distribute their programs uncompiled just to piss everyone off.

 

Post #165858
Posted Thursday, March 17, 2005 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 22, 2008 6:13 AM
Points: 1, Visits: 2

Hi, I have the same problem.

Did you finally find a solution for this ??

If not, where did you find the DecDTSRun.c ??

 

Thank's

Sylvio

Post #168509
Posted Thursday, March 17, 2005 2:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 17, 2005 2:16 PM
Points: 4, Visits: 1

I found the C at the following link.  I hope that you have better luck.  I am still working on this item.

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

Ernest

Post #168528
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse