I have a DTS package in which I have several flows using different connections (OLE DB Providers, etc...) with Login ID and password.
But whenever the password changes, I need to manually update all the connections I have in this DTS. Isn't there an easier way to do that, somewhere via code or something else?
DTS or SSIS?
For DTS questions, see the DTS forum: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg|||
Assuming you're talking about SSIS, you can consider other package protection levels (avoid password encryption) - e.g. ServerStorage.
See http://technet.microsoft.com/en-us/library/ms141747(SQL.90).aspx
No comments:
Post a Comment