Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS Package Details Expand / Collapse
Author
Message
Posted Thursday, May 1, 2008 9:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 3, 2011 9:11 AM
Points: 64, Visits: 104
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.
Post #493712
Posted Thursday, May 1, 2008 9:38 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:27 PM
Points: 33,204, Visits: 15,351
Not really. You could save each package as a VB file and search them or you can open each one.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #493720
Posted Thursday, May 1, 2008 9:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 3, 2011 9:11 AM
Points: 64, Visits: 104
Is there any way to automate this like opening each job and saving it to VBS to check which connection is used?

Post #493726
Posted Thursday, May 1, 2008 10:25 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:51 PM
Points: 4,065, Visits: 5,298
Search SSC for "scripting packages". There are a couple of scripts in the Script section that describe how to output all packages.

Greg
Post #493756
Posted Thursday, May 1, 2008 10:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:27 PM
Points: 33,204, Visits: 15,351
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/







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #493758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse