December 21, 2009 at 12:00 pm
I'm blanking. What do I need to do different when using a connection manager that uses SQL Authentication? It tests just fine in the transfer tasks but when I try to execute the task, it gives me:
[Task Name] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ETAC" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
My connections that use Windows Authentication work just fine. I know there's something I need to different but I can't remember what it is.
Can someone refresh my memory?
December 21, 2009 at 12:23 pm
Without knowing your security and seeing your connection string (please don't post that with username and password data, just to be safe), there's not much I can tell for sure. Have you tested the connection object to make sure it's set for SQL authentication?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 21, 2009 at 12:45 pm
yes, I've tested it and it works. I can do a preview of the data in the oledb from object without problems. It's when I try to execute the task it gives me the error.
This is what I have in the config file
<Configuration ConfiguredType="Property" Path="\Package.Connections[Connection Name].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=Server;User ID=UserName;Password=Password;Initial Catalog=DatabaseName;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;</ConfiguredValue>
</Configuration>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply