I have many DTS jobs that copy files to my SQL server and import them into SQL tables. Is there a way to get a list of all jobs and what files they are accessing?
In sysdtspackages there is an image column packagedata, I am guessing all info is in there but I can't seem to find anyway to read the data in the column.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!