SQL Server Performance Forum – Threads Archive
Script for the name of DTS PackageHi, 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.
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.