SQL Server Performance

How to determine package name - DTSRun ~Z...

Discussion in 'SQL Server DTS-Related Questions' started by DBADave, Aug 24, 2005.

  1. DBADave New Member

    I am supporting servers containing a large number of DTS packages and my DTS knowledge is small. Today a scheduled job failed and the job contained a DTSRun ~Zxxxxxxxxx command. How do I determine the package name to know what package is failing?

    Dave
  2. RGKN New Member

    I'm not sure you can as I think it is encrypted.

    You may be able to find out what has run from msdb for example

    select * from msdb.dbo.sysdtspackagelog
    where logdate > '24 aug 2005'

    Alternatively ask your developers for the documentation of what each scheduled job does.

    Afterwards if you aren't concerned about encrypting the DTS package names make sure that they schedule them by writing the DTSrun command themselves in future rather than being lazy and right clicking to schedule them.

    Regards,

    Robert.
  3. homebrew01 New Member

    Even if you just right click & schedule a DTS, the scheduled job gets the same name as the DTS package, so they should match up unless someone deliberatly changed the sched job name :-(
  4. satya Moderator

    Check the DTS package log for further information on the error, as it is bit tricky to findout from the scheduled jobs as explained above.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page