Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Posts
    14

    Unanswered: Packages related with its jobs...

    Hi,

    I have diferent jobs scheduled in the system but I canīt find which Package is launched by the job. I only have this information: (double click over the job, steb tab, modify button for any job step, in the command text window)

    DTSRun /~Z0x9D852D31537078274085C85BE05756CCE0CA78671EC12A 4BDFFEC4E5E6017E4841EE5F41C492CCAA7F5746CA894011BB 376479B6E679EC3C6045C328D1EF1CDA7CF28B6EEFE9DFE923 7DF5662AE09BD6215C35AA4121BD2DE4433C7BABEE42EC87E7 0F47EA7C01FB44CB28

    I would like to know the Package name related to.

    Any help would be very appreciated.


    Regards

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by anibalgris
    Hi,

    I have diferent jobs scheduled in the system but I canīt find which Package is launched by the job. I only have this information: (double click over the job, steb tab, modify button for any job step, in the command text window)

    DTSRun /~Z0x9D852D31537078274085C85BE05756CCE0CA78671EC12A 4BDFFEC4E5E6017E4841EE5F41C492CCAA7F5746CA894011BB 376479B6E679EC3C6045C328D1EF1CDA7CF28B6EEFE9DFE923 7DF5662AE09BD6215C35AA4121BD2DE4433C7BABEE42EC87E7 0F47EA7C01FB44CB28

    I would like to know the Package name related to.

    Any help would be very appreciated.

    Regards

    Try:

    select * from sysdtspackages where id = '[package id]'

    [edit: d'oh, I should read SQL BOL first! The /~Z is an indicator that the string that follows is encrypted. I do not know SQL's encrption algorithm so I'm afraid I can't really help here.]
    Last edited by hmscott; 10-26-05 at 11:50.
    Have you hugged your backup today?

  3. #3
    Join Date
    Jun 2005
    Posts
    14
    thanks. I have tested the sysdtspackages table but I canīt find any useful information to relate a job with the package that is running.

    Meanwhile I will try SQL BOL.

    Regards

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Is the dts packagae writing a log file in the logs folder of the mssql folder? If not, modify the dts package to write the log. Then, aftter the dts packagees execute, check the log. It will hold the clear text name of the package and the results of each step in the package. You should be able to correlate the run time and the associated package. And if you have to delete old logs, the dts package will recreate them on the next execution.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •