Hello all. This is my first post so thanks, in advance, for your help!!
I have 3 SSIS packages that I have scheduled through SQLAgent that extract data from Oracle and insert it into SQLServer 2005 every morning. The issue is that my logon for the Oracle instance expires every 90 days, so I have to go into each package every 90 days to update my password.
Questions: How can I set up my packages so that I can store my logon info in a SQLServer table so that I only have to change it in one place instead of three?
Regards,
Felix