Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011

    Unanswered: DTS package problem in 2000 server

    Hi All,
    I am having problem in 2000 server where DTS packages got scheduled via windows i need to know what DTS packages are running on the server.Please tell me the solution in brief where i am new to this sql server

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    Check the Windows scheduler. Find the task that schedules the DTS packages. On our system, a .CMD or .BAT file starts a number of DTS packages and other .CMD and .BAT files, that can start other .CMD and .BAT files and DTS packages, ....

    You will have to read all .bat and .cmd files to find out what DTS packages are started and their sequence.

    This describes our system. I can't tell how yours is organised. Hope this helps.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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