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...
thayduckProgrammer AnalystAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ValentinoVConnect With a Mentor BI 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
 
thayduckProgrammer AnalystAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.