sql server dts: SQL Server Agent job with DTS -- sql server dts

SQL Server Agent job with DTS

Don R.
1/31/2006 10:26:28 AM

sql server dts:

We have jobs that have steps that run DTSs. Unfortunately, the setup of the
jobs were not documented very well. The DTS run command has an encrypted
value and the Step Name was not set to the actual name of the DTS. Is there
anyway to determine the english name of the DTS from the encrypted value in
the DTS Run comman in the step? Any help would be appreciated.

Thanks,

Re: SQL Server Agent job with DTS

Sue Hoegemeier
1/31/2006 9:54:51 PM

You could run a trace when the jobs run to get the package
name. Capturing SQL:StmtCompleted or SP:Completed will give
you TextData values along the lines of:
exec msdb..sp_get_dtspackage N'YourPackage', null, null

Only other way I can think of would be to decrypt the
command. Search the web for DTSRunDec for a tool that can
decrypt the command.

-Sue

On Tue, 31 Jan 2006 10:26:28 -0800, Don R.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.