InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:57:42 GMT20http://www.sqlservercentral.com/Forums/Topic1434109-391-1.aspxUpdateI dint change anything , now the Test connection is succesful thru Oracle Connection manager in BIDS , but i am getting the same error while i am executing the ssis packgeThu, 21 Mar 2013 19:27:18 GMTSQListichttp://www.sqlservercentral.com/Forums/Topic1434109-391-1.aspxHi All, Scenario: Migratin Oracle to SQL Server Issue: I was succesfully connected to Oracle from SQL Server 2008 R2 from a different box and imported data, now I am on windows 2012 server, where there is already a named instance of SQL Server 2012, now i installed other SQL Server 2008 R2 instance on the same box and trying to connect to Oracle from 2008 R2 instance. It is failing with following error But I tried to connect to oracle using same oledb from import export wizard and it is successfully connecting :( TITLE: Microsoft Visual Studio ------------------------------ Error at Tets [Connection manager "SourceConnectionOLEDB"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF. Error at Data Flow Task 1 [Source - XXX_XXX_XCC_XXX[1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ Please Help meThu, 21 Mar 2013 19:24:02 GMTSQListic