SQL Server Performance

Script for the name of DTS Package

Discussion in 'SQL Server DTS-Related Questions' started by gk_sql, Mar 4, 2007.

  1. gk_sql New Member

    Hi,

    The following command calling a DTS package. We have around 100 DTS packages in the server. Can any body share the command or script to view , which DTS package the command is callling.


    DTSRun /~Z0xE4F4A631AB328115046DC96894C2D211AE867997188C266D3FFBD98FF771BF8F29E6E2B1559C0CBD652BAB2F5C42924BDBF19452398575FEEA49EEA9FB81B54FBE0A52FD7C80AC957566CC77E4E8E9CE15D4EB11EC195EC91C7D33


    Thanks
    Gopi
  2. satya Moderator

    You have to search for that referring to sysdtspackages system table and look at the schedule over ther.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page