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