Oracle to SQL in SSIS - ETL

820 Views Asked by At

i am trying to get data from oracle database to sql database i have 3 environments

  1. Oracle development server 1
  2. SQL development server 2
  3. my local host window 8.1 64 bit with SQL data tool 2012

now when i go to add new connection manager under connection manager to connect to oracle server, i am not able to see the oracle connection manager type, i know that i have to install oracle client, but where to install it? in my machine or in the oracle server.

i already downloaded "Microsoft Connectors v2.0 for Oracle and Teradata" and install them in my machine. but still nothing happened, i cant see the connection manager

  • AttunitySSISOraAdaptersSetup.msi
  • AttunitySSISOraAdaptersSetupX64.msi

in SSIS toolbox i was able to see oracle destination and source component.

i searched the net for a step by step article on how to do this but no luck

please help.

thank you

0

There are 0 best solutions below