0

I have 100s of packages in my current production server. I have to check the server and DB details of all these stored SSIS packages. The packages are available under Server>Stored Packages>File System.

The manual way is to download each package and check the connection managers. Is there any other easy way to do this?

p2k
  • 2,126
  • 4
  • 23
  • 39
  • If you had stored the connection strings in .config files you could check those instead, but you'd still be checking 100's of files, so I don't know if I'd call it "easy". – Tab Alleman Jul 20 '15 at 14:02
  • 3
    SSIS package or *.dtsx file is basically an XML file. If you open that file in textpad you would see XML tags and the `` tag would have all connection objects used in that package. Now you can develop a script which can go thru all 100s of files and search for text between the start and end tag of `` that would give you the connection strings. You could use .net (C#/VB) to develop that script, or you can make another SSIS pacakge with script task which can run thru all 100s of XMLs. – Jigar Jul 20 '15 at 14:25

0 Answers0