thayduck
asked on
SSIS Connection Manager Password Disappears
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 password disappears. When I try to execute the package, it fails saying the password is missing.
I also setup a DSN with the user name and password, but I still have to key in the password before I can press test connection. And again, as soon as I click OK in connection manager it disappears. Now the password remains in the DSN but not in the connection manager I created.
When I look at the properties of the Connection, the password is there but encrypted. But it is there.
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 password disappears. When I try to execute the package, it fails saying the password is missing.
I also setup a DSN with the user name and password, but I still have to key in the password before I can press test connection. And again, as soon as I click OK in connection manager it disappears. Now the password remains in the DSN but not in the connection manager I created.
When I look at the properties of the Connection, the password is there but encrypted. But it is there.
There should be a "Save My Password" checkbox right below the Password textbox
ASKER
I am executing the Connection Manager I created. It asks for password, I key it in, click OK and tells me connection to DB2 was successful. There is no Save Password check box. I execute same Connection again, and password is gone, so I have to key it in again.
ASKER
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. This helped solve my issue.