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


    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

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