November 20, 2002 at 1:08 pm
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
November 20, 2002 at 7:12 pm
I don't believe there is a way with a decryption tool and I don't know of anything built around this particular need.
November 21, 2002 at 6:40 am
Hi,
I assume that we can get this inforamtion from some system tables in MSDB.I think sysdtspackages is a good guess.
regards
Elias
November 21, 2002 at 10:25 am
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.
November 21, 2002 at 11:35 am
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
November 21, 2002 at 2:13 pm
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
November 21, 2002 at 2:50 pm
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
November 21, 2002 at 2:55 pm
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
November 21, 2002 at 3:06 pm
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.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply