Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  SQL Connection in DTS

Author  Topic  vusil Starting Member 22 Posts Posted - 2005-10-27 : 06:23:44 Hi guys, Is there a way to read the username used to connect to a SQL connection in a DTS package without using EM? We have some connections that use the developer's logins and some of the delopers have since left. I have to go through the connections and change the login credentials so all use the same. Please say there is a way; I don't fancy going through each package! Thanks in advance for your SQL wisdom.