Heres a scenario: Your given a SQL database with a set of scheduled jobs and need to find out exactly what these jobs do. You begin running into a problem when all of the DTS steps look like this:
Notice the DTSRun parameters were encrypted with the dtsrunui tool. The good news is that most anything that can be encrypted and distributed can be decrypted. Fortunately a tool already exists to handle decrypting this text.
Visit SqlSecurity http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
and download the "DTSRunDec" zip file.
File contents:
build.cmd
DTSRunDec2.c
DTSRunDec.c
readme.txt
Note: You will need Visual Studio to compile this tool, or search the web for a pre-compiled version. Compile by navigating the visual studio command prompt to the unzipped files and running build.cmd.
Drop the newly compiled executables in a directory that is accessible from your PATH and you are ready to start decrypting.
Decrypt a string by copying the text that follows "DTSRun /~Z" into your command window as shown below.
DTSRunDec should give you a clear readable version of the parameters.