Home > IT Answers > Microsoft Windows > DTS Package information
Jaylou
0 pts.
 DTS Package information
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Hi all, 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. TIA, Joe

Software/Hardware used:
ASKED: July 5, 2006  10:58 AM
UPDATED: July 6, 2006  7:23 AM
RELATED QUESTIONS
Answer Wiki:
Hi Jaylou, You can use the Interop.DTS library in .NET to inspect and return information about DTS packages. If you'd like an example VB.NET application, let me know; I have one that inspects the SQL tasks for a string. You can definitely alter it to look for information in other properties of DTS packages.
Last Wiki Answer Submitted:  July 6, 2006  7:23 am  by  Kamiilihp   0 pts.
All Answer Wiki Contributors:  Kamiilihp   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _