• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

SSIS 2008 connection to DB2 keeps asking for a password

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.

Help...
0
thayduck
Asked:
thayduck
1 Solution
 
ValentinoVBI ConsultantCommented:
Can you try configuring the connection manager using package variables to see if that solves the problem?  Especially the properties related to credentials.
0
 
thayduckAuthor Commented:
Thanks.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now