Solved

SSIS 2008 connection to DB2 keeps asking for a password

Posted on 2014-02-18
3
493 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

622 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