Have a small SSIS package that connect to DB2 to extract a currency exchange rate.
I created a connection that needs a user id and password to connect to db2.
When I key in user name and password, and click Test Connection, it connects fine.
As soon as I click OK on new connection manager I created, the user name and password disappear. When I try to execute the package, it fails saying user id and password missing.
I also setup a DSN with the user name and password, but I still have to key in user name and password before I can press test connection. And again, as soon as I click OK in connection manager they disappear. Now the user name and password remain in the DSN but not in the connection manager I created.