sql server dts: I'm in a new position, without documentation, and I am attempting to
document the jobs and dts's.

My problem, is that when I see the jobs, all of the DTS's id are
encrypted (/~Z0x....).

How do I identify the DTS from this encrypted id, without executing the
DTS.

Many Thanks,

Hello dbaNelson,

Google for a utility to do it (there is one) OR follow what happens in Profiler

Allan

[quoted text, click to view]

See the following article:
http://blogs.technet.com/vipulshah/archive/2007/03/12/how-to-identify-which-dts-package-is-being-called-by-scheduled-job.aspx

It explains a very easy way to do what you are wanting to do.

From http://www.developmentnow.com/g/103_2006_1_0_0_676397/How-to-Identify-a-DTS-job-from-an-encrypted-Z-dtsrun-command-line.htm

Posted via DevelopmentNow.com Groups