Re: Decrypt DTS package from scheduled job

#1

I seem to remember seeing a tool that does this on the net somehwere.

Why not though Profiler the server when you execute the command and see
which package is called.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Doug Guerena" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is there a way to decrypt the DTS Run command line parameters to find out
what DTS Package is tied to a job?

#2

Use dtsrunui utility from a command line to generate an unencrypted dtsrun command. The create a SQL Agent job and a step in it with CmdExec type and paste the string as a command

Soloist

#3

In message <D587745C-45E7-4847-BF0C-500D917D4D02 (AT) microsoft (DOT) com>, Doug
Guerena <anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Is there a way to decrypt the DTS Run command line parameters to find
out what DTS Package is tied to a job?

Unfortunately the encryption is now broken, see DTSRunDec on -
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

You will need to compile it first, run Build.cmd from a VS Command
Prompt.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Decrypt DTS package from scheduled job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Decrypt DTS package from scheduled job - 03-04-2004 , 04:08 PM

Re: Decrypt DTS package from scheduled job - 03-04-2004 , 05:01 PM

Re: Decrypt DTS package from scheduled job - 03-04-2004 , 05:29 PM