September 3, 2007 at 7:05 am
Hi
I have a SISS package that have been working without any problem, today when I try to execute it from within the package itself, I get the following error:
Error: 0xC020801C at Data Flow Task, Destination - CSMStock [34]: The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009.
Error: 0xC0047017 at Data Flow Task, DTS.Pipeline: component "Destination - CSMStock" (34) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "RapidStock.dtsx" finished: Failure.
I dont understand what have happened...have seen others have had this problem....but no conclusion have come to my mind.can someone please help....seems like the package cant use my connection for some reason...nothing programatically is changed since the last time it worked ?????
br
Helmut
December 17, 2008 at 9:31 am
I am having the exact same error trying to replicate to three of my 13 remote sites.
The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009
The SQL Server Agent Accounts are exactly the same at each end, yet I still get this error.
Does anybody even read these forums?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply