Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS 2008 connection to DB2 keeps asking for a password

Posted on 2014-02-18
3
Medium Priority
?
506 Views
Last Modified: 2016-02-10
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
Comment
Question by:thayduck
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 1000 total points
ID: 39869545
Can you try configuring the connection manager using package variables to see if that solves the problem?  Especially the properties related to credentials.
0
 

Author Closing Comment

by:thayduck
ID: 39874654
Thanks.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question