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.
July 5, 2006 10:58 AM
July 6, 2006 7:23 AM