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

how to load oracle database data to sql server with the help of SSIS Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 6:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 8:44 AM
Points: 2, Visits: 6
how to load oracle database data to sql server with the help of SSIS
Post #1567200
Posted Friday, May 2, 2014 11:49 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 1,536, Visits: 4,253
First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard and save as package, then import the package into a SSIS project.

Post #1567219
Posted Tuesday, May 13, 2014 8:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 8:07 AM
Points: 4, Visits: 1
Use Oracle Provider for Connection Manager in SSIS
Post #1570613
Posted Wednesday, May 14, 2014 12:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 13,538, Visits: 10,412
You create an OLE DB connection using the Oracle OLE DB provider.
Make sure the Oracle client tools and the ODAC components are installed on the development machine.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1570643
Posted Wednesday, May 14, 2014 8:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 8:07 AM
Points: 4, Visits: 1
Koen Verbeeck (5/14/2014)

Make sure the Oracle client tools and the ODAC components are installed on the development machine.


Good point, I forgot to mention it.
Post #1570857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse