InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 00:14:45 GMT20http://www.sqlservercentral.com/Forums/Topic493712-19-1.aspxI'm sure there is. Likely you're use a VBScript and open the packages with the DTS objects, then save them out as a different file. you'd have to look around for the exact features of opening a package and then saving off.I'd try here: http://www.sqldts.com/Thu, 01 May 2008 10:27:44 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic493712-19-1.aspxSearch SSC for "scripting packages". There are a couple of scripts in the Script section that describe how to output all packages.Thu, 01 May 2008 10:25:34 GMTGreg Charleshttp://www.sqlservercentral.com/Forums/Topic493712-19-1.aspxIs there any way to automate this like opening each job and saving it to VBS to check which connection is used?Thu, 01 May 2008 09:42:10 GMTRamesh Lendehttp://www.sqlservercentral.com/Forums/Topic493712-19-1.aspxNot really. You could save each package as a VB file and search them or you can open each one.Thu, 01 May 2008 09:38:24 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic493712-19-1.aspxHi, I have 2000 DTS packages in production. Packages are created by various users. Each package in turn is pointing to different databases. Is there any way to find out which userid/password/Database is used inside DTS to connect to database?Thanks,Ramesh.Thu, 01 May 2008 09:35:03 GMTRamesh Lende