Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Posted Wednesday, July 24, 2013 4:49 AM


Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 449, Visits: 1,054

I have a OleDB connection mgr being used in a SQL Server Destination task in a pkg in which I want to use SQL Authentication with the username and pasword of a SQL user which has already been granted access to the database. When I open the connection mgr and type in the password and click save password then click test connection it connects but when I run it I get the following error. and after I open it again the checkbox for saving the password is still checked but the textbox where I typed the password is blank.

[SQL Dest - Tbl_BOM [23]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "C9100970E1DB44B.HDC.HDC_Worker" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Post #1476974
Posted Thursday, July 25, 2013 10:34 AM


Group: General Forum Members
Last Login: Saturday, May 21, 2016 11:48 PM
Points: 151, Visits: 713
Later version - Same Error. The answer for me was to create a configuration file for the SSIS package. The problem was that Microsoft is being security conscious. Also, I am using windows authentication. The full answer is to create the configuration file and then exit from the editor and edit the configuration file separately in notepad or some other text editor. The passwords are not saved and will be removed from the package and the configuration file when you edit it even though you tell it to save the passwords.
Post #1477623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse