How to find the DTS Name

  • 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

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

  • Hi,

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

    regards

    Elias

  • 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.

  • 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

  • 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

  • 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

  • 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

  • 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