Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle to 2008 R2 SSIS Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 7:24 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:46 PM
Points: 235, Visits: 981
Hi 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 me
Post #1434109
Posted Thursday, March 21, 2013 7:27 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:46 PM
Points: 235, Visits: 981
Update

I 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 packge
Post #1434110
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse