This is exactly what I have done!!!

I have my information in a table on the server and then I query the table to retrieve the connection password and save this to a global variable.  I then set the password of the connection object to what is in the global variable via ActiveX Script.

So essentially, I'll need to just add this piece of code to all of the DTS packages.  After that is accomplished, all I'll have to do is set the password (which changes every 60 days) in one place and all of the DTS packages will automatically be updated.

Are there other things that anyone can suggest that this type of solution be applied to???  If I've got to update each DTS, I might as well do it right the first time.

Thanks,

Brian