March 16, 2005 at 9:58 am
I have many DTS packages on many servers (I am new Job) that in turn have many connections to many servers. What I want to do is find out what connections are in each package, I then can see if these connections are valid (the server, database is still in use)
The packages have been written by developers over time, and I want to clean them up. What I would idealy want is a way to do this without opening each package in design view. Is there a way to enumerate the connections in a package without opening it?
March 16, 2005 at 12:33 pm
I don't believe there is a way to do this without writing a program with SQL-DMO. You would need to open up each package in code and loop through the connections.
March 16, 2005 at 2:33 pm
Andrew,
You can access the DTS object model through VB or VBScript and loop over the connections collection to get the properties that you are interested in.
In BOL look for "DTS Package2 Hierarchy" for an overview of the DTS object model. That's a good place to start.
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply