May 1, 2008 at 9:35 am
Hi, 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.
May 1, 2008 at 9:38 am
Not really. You could save each package as a VB file and search them or you can open each one.
May 1, 2008 at 9:42 am
Is there any way to automate this like opening each job and saving it to VBS to check which connection is used?
May 1, 2008 at 10:25 am
Search SSC for "scripting packages". There are a couple of scripts in the Script section that describe how to output all packages.
Greg
May 1, 2008 at 10:27 am
I'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/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply