I am trying to port a job where there are several DTS packages in various
steps being called from cmd. How can I identify what package names are
associated with what job step so I can move the DTS packages as well?

thanks
Meenal

Last time I checked, you cannot do this by using any SQL Server tools. The
reason being that if you decrypt the package name you could also decrypt
usernames and passwords that might be stored in the same execution string.

I got this answer directly from a technical lead and am escalation engineer
at Microsoft support services for SQL when I worked there last year.

There may be 3rd party utilities for this...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site



"Meenal Dhody" <meenal_dhody (AT) hotmail (DOT) com> wrote

Hello Meenal,

I presume the reason you ask is that the DTSRUN cmd in the step looks like
this

DTSRUN ~/Z<etc>

There is a tool which will crack this out there on the net but you could
also run profiler and see which package gets picked up from MSDB if the package
is in MSDB of course.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com