How to update DataSource UserName/Password changes in a DTS Package
-
Hi
How to change the datasource UserName/Password changes in a DTS Package which consists of around 25 tables of data transfer.
There are around 50 Packages which involves data transfer from DB2 to SQL Server. Suddenly DB2 DBA changed the password to access the DB2, so need to configure the datasource once again.
Now I need to update this datasource (with new user name and password) in all the DTS Packages.
Any simple way to do this? rather than going on all packages and open to update this change
Thanks,
Adi
-
IF you have this hard-coded in the DTS packages there is no way around... IF you use UDL file or some other mechanism for the connection change in 1 place should suffice across the board..
Good Hunting!AJ Ahrens
webmaster@kritter.net -
There is no "simple" way
One option is to write a VBScript to programatically open the package change the properties and save the package again. Modifying the pacakge this way will lose the layout and any text annotations. If you must maintain these items the you have no option but to manually change each package. Look at it as a learning exercise for how to design future packages
Take a look at this article,
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp
it provides some good guidelines on developing packages. The section headed "Metadata-Driven Approach" deals with this particular issue.
--------------------
Colt 45 - the original point and click interface
-
Phill,
Thanks for your message and URL. I could understand about the best practises, but unable to implement as the packages are existing already. Anyway I will try to VBScript program for the same. I have given the best practises to the concerned team already.
Adiseshan
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply