Very Computer

by **Andy** » Wed, 03 Oct 2001 06:30:51

I've inherited a legacy system with a package that runs every day.

SQL Agent lists the job step as
DTSRun
/~Z0x6676B2D8C4B8B901FD1FA55A247CFF6A1D3E5143E6B580F64C118EB5A9E6F6447EDEA75
1A0462Cetc.

How can I decipher what package this corresponds to? Someone has renamed
all the packages so I can't use that info from the Job Step.

Thanks.

by **Mike** » Sun, 07 Oct 2001 01:43:37

Check the tables in the MSDB database on your SQL Server.

On my SQL 7 server:

Local Packages are in: sysdtspackages and your ID code maps to an ID field there.

I'm not certain where meta data services packages are stored. they may be there as well.

And Duh... I just noticed, if you open each package and bring up it's properties, you get the name plus the Package ID. So that may be the brute force method of finding it out.

> I've inherited a legacy system with a package that runs every day.

> SQL Agent lists the job step as
> DTSRun
> /~Z0x6676B2D8C4B8B901FD1FA55A247CFF6A1D3E5143E6B580F64C118EB5A9E6F6447EDEA75
> 1A0462Cetc.

> How can I decipher what package this corresponds to? Someone has renamed
> all the packages so I can't use that info from the Job Step.

> Thanks.

by **Darren Gree** » Fri, 12 Oct 2001 05:47:12

Quote:>Check the tables in the MSDB database on your SQL Server.

>On my SQL 7 server:

>Local Packages are in: sysdtspackages and your ID code maps to an ID field
>there.

>I'm not certain where meta data services packages are stored. they may be there
>as well.

Meta Data packages are stored in MSDB, but there is no one table like
sysdtspackages. It has also changed between 7.0 and 2000. Don't go
there, use the object model.

>And Duh... I just noticed, if you open each package and bring up it's
>properties, you get the name plus the Package ID. So that may be the brute
>force method of finding it out.

>> I've inherited a legacy system with a package that runs every day.

>> SQL Agent lists the job step as
>> DTSRun
>> /~Z0x6676B2D8C4B8B901FD1FA55A247CFF6A1D3E5143E6B580F64C118EB5A9E6F6447EDEA75
>> 1A0462Cetc.

>> How can I decipher what package this corresponds to? Someone has renamed
>> all the packages so I can't use that info from the Job Step.

>> Thanks.

If you look in Books Online for DTSRUN, /~Z or /Z as it is also
(incorrectly) documented means that this is a single encrypted parameter
that contains all the information such as serevr, connection details,
and package details used to schedule execute that package.

You cannot decrypt this. Normally both the job name and step name are
the same as the package name. If the package has been renamed I guess
the jobs will fail as it can no longer find the package.

--
Darren Green
http://www.sqldts.com

Very Computer

Help with DTS package.

Help with DTS package.

Help with DTS package.

Help with DTS package.