Sirisha Kommushetty


Error at Text Inbound Task [SQL Server Destination [9]]: The AcquireConnection method call to the connection manager "Server.Northwind" failed with error code 0xC0202009.

Error at Text Inbound Task [DTS.Pipeline]: component "SQL Server Destination" (9) failed validation and returned error code 0xC020801C.

Please keep me posted with alternate work around(s) /solution(s).





Re: The AcquireConnection method call to the connection manager "Server.Northwind" failed with Error code 0xC0202009;

Phil Brammer


Try using the OLE DB Destination instead.