I have almost a hundred SQL Server DTS packages that run mostly in the morning. Most of these utilize a particular Oracle DB that requires the monthly changing of passwords. As you can imagine, this is a gigantic pain in the ass if I have to go through and change all the passwords individually in every package.
Is there some kind of way to set up a universal connection type that's the same across all packages? Or maybe I can make my password be a global variable or something?