I'm having an Authentication issue. I have created a package to merge the data from two tables in Oracle to a single table in SQL Server. When editing the connections in connection manager, everything is fine, I can connect to the Oracle DB. However, when I run the package, I get an invalid username/password. When i "view code' I see that there is of course no password for the oracle connection. If I manually type one in VIA the code view and save, then run the package, the connection to Oracle works fine. Of course everytime I edit the package again in design view this removes the password requiring me to re-enter it. I've checked the "keep password" box, and the -property for "Persist Security" is TRUE, yet the password is never available at package runtime. What can I do to make sure this is available without having to manually enter this?

I've even tried saving the config settings to a .XML file and to the SQL Server in a table. No dice... I'm sure I'm simply missing a setting somewhere but I cannot find the documentation with searches... Help appreciated, thanks!

--
Dave Hauze