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

Decrypt DTSRun package name Expand / Collapse
Author
Message
Posted Friday, February 2, 2007 2:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:48 AM
Points: 199, Visits: 196
It is possible to decrypt the name as I once found a utility written by a Russian dude which did it. It was a bit scrappy and errored but it did return the name correctly. Sadly I've lost it but I'll see if I can't hunt it down again and I'll post the link here if so.


Post #341941
Posted Friday, February 2, 2007 3:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:48 AM
Points: 199, Visits: 196

Further to my last post, whils searching for DtsRunDec (the decoder app), I found this thread on sqlforums.com. One chap (jamespua, near bottom of page) says that if you use the DTSRun utility but add the switches /!X /!C at the end, the utility will decode the name for you (without executing the package) and put the decrypted run string into the cliboard which you can then paste out at will. Having tried it, it works perfectly.

Example:

DTSRun /~Z0xDECE772DF6021A7ED260B31A2A37454F9614F6426C26B75B35481216F12946BB2ED19DC1E116ECD0C39E279544DAEE48E088FCE1CD35D0A1A99E11530ED82E9E97FF95CD4ECB7AD5D56F66CA8CC060E3E08B99BF3478B3DF4ADFD1912C097B77C9C2C44419F78FC5C7B6E8A269A9840E5387B48AB10106F2AECEDBE59C1DB35A7811F81D04ABF01F5E67C148778028B165D51BDF88DEE3CBF8F7582B6CA554D826B9BB /!X /!C

 

Gives:

DTSRun /S "<server>\<instance>" /U "<uid>" /P "<pwd>" /N "<package name>" /!X /!C

 

Obviously, names have been changed to protect the innocent!! Top marks to jamespua on sqlforums for such a handy tip. The full documentation for DTSRun and it's switches is here.

 

Enjoy!




Post #341944
Posted Friday, February 2, 2007 10:59 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 9:17 AM
Points: 4,065, Visits: 5,316

No kidding?!  I tried using the arguments also and it does work.  Who knew that was right under our noses
all this time? 

Thanks!

Greg



Greg
Post #342124
Posted Tuesday, March 27, 2007 11:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 30, 2007 11:11 PM
Points: 1, Visits: 2

Thanks for the Post Greg
Can you please send /attatch the complied tool as was unable to find the same on site address mention above.
Regards
Aks

 

Post #354383
Posted Thursday, May 1, 2014 3:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:49 AM
Points: 163, Visits: 831
Mods - I KNOW it's an old thread, but I'm sure it's writeable for a reason....

Just to add, after having run DTSRUn with the above switches, you may just see the messages

Loading...
Executing...

This is NOT actually executing - I just checked the history.

To bring up a command containing the package name, just right click inside the CMD box.

Cheers guys!!

Jake
Post #1566655
Posted Thursday, June 12, 2014 1:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 1, Visits: 2
Use the /!X and /!C parameters after the DTSRun command (/!X says do not run and /!C says copy results into clipboard). You will get the package name in clear text in your clipboard. Paste to notepad, and you will see it.

Detail is here:
http://www.rdacorp.com/2008/08/decrypting-the-encrypted-dtsrun-z-command-line-parameters/

1. Copy the DTSRun command line from the job step (including the very long encrypted string!)
2. Open a Windows Command Line Window and paste the command into it.
3. Add /!X and /!C to the end of the DTSRun command. (/!X says do not run and /!C says copy results into clipboard)
4. Execute the command. (You should see DTSRun: Loading … and DTSRun: Executing …. as is displayed below and the cleartext parameters should now be in your paste buffer)
5. Paste the cleartext parameter string into notepad.


Post #1579893
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse