How to find the DTS Name

Question

Post reply

How to find the DTS Name

YeePee

Mr or Mrs. 500

Points: 561
More actions
November 20, 2002 at 1:08 pm

#58417

Hi All,
I have a SQL Server Scheduled job which is using Local packages under DTS. If I look under the steps of the job, one step is
encrypted like below.
"DTSRun /~S 0x48680976FBA2429AE6548F959D34ABC80FCA268F158812A0 /~U 0xF8141F8065D98248 /~P 0x2921675182DD69D9007103D19E46EAB2 /~N 0xEF81FBEFE60680AA795A4158168EFA7F8AF5D207BB801A3BD4037AB75DDBD5BCA785A393E51D35C8C86DEE6A9014830275D32CBB6BA753FF"
Is there any way can I find out which local DTS package this job is executing.
Thanking you all for the support.
Elias

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

I don't believe there is a way with a decryption tool and I don't know of anything built around this particular need.

YeePee Mr or Mrs. 500 Points: 561 More actions · Answer 2

Hi,

I assume that we can get this inforamtion from some system tables in MSDB.I think sysdtspackages is a good guess.

regards

Elias

Mkumari Hall of Fame Points: 3498 More actions · Answer 3

How many DTS packages do you have,If not too many,try to create a new job for each of them and compare the encrypted names.

ewilson10 SSCarpal Tunnel Points: 4255 More actions · Answer 4

I believe the creating new jobs strategy would fail since a different encryption line is generated each time. Also, the sysdtspacakges table versionid field does identify the package but once again due to encryption ...

The only thing I could find is that if the DTS package was sceduled from the DTS Package interface then the Job 'Step Name' will be the name of the DTS package.

Everett Wilson
ewilson10@yahoo.com

YeePee Mr or Mrs. 500 Points: 561 More actions · Answer 5

Hi ,

I found that if we use the same DTS the ~P

field (I assume that it is password ) only changes.

DTSRun /

~S 0x48680976FBA2429AE6548F959D34ABC80FCA268F158812A0 /

~U 0xF8141F8065D98248 /

~P 0x2921675182DD69D9007103D19E46EAB2 /

~N 0xEF81FBEFE60680AA795A4158168EFA7F8AF5D207BB801A3BD4037AB75DDBD5BCA785A393E51D35C8C86DEE6A9014830275D32CBB6BA753FF

If we look at the ~N field it seems to be of

Binary Image.Is there any way of displaying this Binary Image.

I was unlucky on "Job 'Step Name' since the person created it as Step1 .

regards

Elias

dm Ten Centuries Points: 1135 More actions · Answer 6

Double click on the job and look in the description text box. When a DTS package is scheduled, this is automatically filled in. The package name should be their unless someone deleted it.

Diane

YeePee Mr or Mrs. 500 Points: 561 More actions · Answer 7

Hi,

Since the Job Description and Step Name can be edited, the programmer who created this named it according to his discretion.

It no longer contain the original name .

regards

Elias

Antares686 SSC Guru Points: 125444 More actions · Answer 8

If it gets run periodically you may could run yourself anyway without harm in a cmd prompt with the string you have, might have some details then in the cmd prompt give you an idea which to look at.