September 13, 2004 at 9:46 am
How can I find a DTS package name from this bit of information:
DTSRun /~Z0x17073904118E47D68C03A688F2576339E0DFB6FFA29AA87D15106238F99BCE2A8A340902756C63362273527870FF4843D7271362C3DAEC2283BE30CFA8C8CBFF213885721602AB248BC2F4DEC134BFB3AA00DBE6441D8A93368E1565FB659B8BCACBEF9ABC096F1A45D9E05A2D4D8C617D2A52BD0476FE94DA86CD450E98AA5AA6F724414F28FC4C82E2E2BA9FA068C09032E21AE47D3CA7AA323C7B4AE438B96198606CEAF782655E0A87E9D62831E346871D649C66A27981F019879A096C719C507F182F26A9545C6076B4A54138666195A88C00B23497671C85BCC05402CEBAA694BB0139A3F07A7A52194597944758FF0D692DE035FB967B13A920720C14A5980A
September 14, 2004 at 12:41 am
I don't think you can. I spent a day or so looking into exactly that issue. That long string of numbers and letters is a one way hash of the name of the package and, I think, execution parameters for DTS run. It's created with the same hashing algorithm that SQL uses to encrypt it's passwords. I know of no way to reverse it and repeated encryptions of the same string don't result in the same hash value. If you're interested, the functions used are 2 undocumented commands: pwdencrypt to create the encrypted string and pwdcompare.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2004 at 9:00 am
As mentioned above, this is an encrypted string, normally created by right-clicking on a DTS package and selecting 'Schedule'. If this is the method used to schedule the job, then the name of the job will reflect which DTS was used to create the job. However, you can change the job name after the fact or DTSRUNUI.exe could have been used to create the string, with the encryption option checked. This tool (dtsrunui.exe) is an excellent resource for building the string to execute a DTS and you have the option of encrypting or not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply