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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics