1

I am new to Oracle database. I am trying to connect the SQL server using SSIS package to Oracle database which is present in different machine.

There is default Oracle provider in SSIS but it's not connecting to the database. I use db visualizer for creating Oracle database in the server machine.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Vignesh Kumar
  • 31
  • 1
  • 3
  • You need to install the Oracle _client_ on the machine running SSIS in order to connect to Oracle. Here's some downloads although I'm not 100% certain which one you need http://www.oracle.com/technetwork/topics/winx64soft-089540.html. PS in future please explain the issue don't just say "it's not connecting" - you need to post the error – Nick.Mc Jan 12 '18 at 14:08

1 Answers1

2

You need to install the "Oracle Data Access Components" or "Oracle Client" on your machine.

There are a lot of step-by-step article on how to connect to Oracle using SSIS:

Oracle ODAC download link

Hadi
  • 36,233
  • 13
  • 65
  • 124