Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  Other Topics  SSIS : Oracle OLE DB Destination

Author  Topic  RaiNy Starting Member 1 Post Posted - 2009-03-02 : 21:45:30 Hi, I build SSIS to integrate data from .mdb (Access) to Oracle. I'm using Oracle 10g. For the connection in SSIS i'm using "Native OLE DB\Oracle Provider for OLE DB", but when i'm running the task, it gives me this error : --------------------- [OLE DB Destination [237]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Oracle" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [DTS.Pipeline] Error: component "OLE DB Destination" (237) failed validation and returned error code 0xC020801C. [DTS.Pipeline] Error: One or more component failed validation. [Connection manager "Oracle"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-12520: TNS:listener could not find available handler for requested type of server". ------- does anyone know why i get this error and how to solve them. Thank you