Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5648
  • Last Modified:

using ssis to copy oracle table to sql server table

I have no experience with Oracle. I need to copy some tables from an Oracle database to an sql server database. I plan to use SSIS to do it. Is there anything special I will need to know to do this?
0
qbjgqbjg
Asked:
qbjgqbjg
  • 2
2 Solutions
 
Mandeep SinghDatabase AdministratorCommented:
Hi,

Some basic points are:

1. if oracle and sql machine are not same. install oracle client on sql machine.
2. setup connection setting on tns.ora on sql machine.(do port opening between for communication).
3. then create a ssis package to transfer data.

try this: http://www.mssqltips.com/sqlservertip/2011/export-sql-server-data-to-oracle-using-ssis/

Refrence:
http://stackoverflow.com/questions/10944968/create-a-ssis-package-to-copy-data-from-oracle-to-sql-server
0
 
qbjgqbjgConsultantAuthor Commented:
Can you explain step 2 a little more.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
First install oracle client in your MS SQL Server based on the version i.e 32bit /64bit. then setup the connect string using TNSNAMES.ORA which will communicate between SQL Server and database server.

Check these below doc for more info.
http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/
0
 
qbjgqbjgConsultantAuthor Commented:
Thanks for your help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now