July 24, 2013 at 4:49 am
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.
July 25, 2013 at 10:34 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply