SQL SERVER 2008 R2
Thanks.
I have tried with different Oracle driver *32 and *64 and I tried by creating a file.dtsConfig file with:
<Configuration
ConfiguredType="Property"
Path="\Package.Connections[oaprd1.oocint1].Properties[Password]"
ValueType="String"><ConfiguredValue>password</ConfiguredValue>
and it does not work: I have the same error plus an error Tag was not close. Any idea?
March 12th, 2011 5:15am
I get the error:
SSIS package "Package_TEST.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC020801C at Data Flow Task, OLE DB Source 1 [32]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "SS_DOM.SS_TEST_PASS_IAR1" failed with error code 0xC0209303.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error:
0xC0047017 at Data Flow Task, SSIS.Pipeline: component "OLE DB Source 1" (32) failed validation and returned error code
0xC020801C.
Error:
0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error:
0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Package_TEST.dtsx" finished: Success.
Do you have any clue to solve it?
Thanks
Free Windows Admin Tool Kit Click here and download it now
March 12th, 2011 5:43am
The problem comes from OLE DB Connection manager. Check the following threads:
http://social.msdn.microsoft.com/Forums/is/sqlintegrationservices/thread/920a0817-d9b8-4766-b0bf-baa6430acf93
http://blogs.msdn.com/b/ramoji/archive/2009/03/10/the-acquireconnection-method-call-to-the-connection-manager-failed-with-error-code-0xc0202009.aspx
Please mark as answer if this helps. Thank you.
http://thebipalace.wordpress.com
March 12th, 2011 6:13am