• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2915
  • Last Modified:

How to connect SQL Server 2005 to Oracle 10g database.

Dear expert,
I am trying to make connection from SQL Server 2005 through OLE DB object in SSIS. How can I make the connection? What should I do on Oracle side?

Thanks!
0
johnyue
Asked:
johnyue
  • 2
1 Solution
 
Einstine98Commented:
On SQL Server side (or more so on the machine where you're running SSiS) you need Oracle Client installed an properly configured to connect to the oracle DB.

on oracle side you need to have a database user configured with proper access... use that username/password to access your data from SSIS side.
0
 
johnyueAuthor Commented:
Hi Einstine98,
Thank you very much for your quick response. I do not know much about oracle side. I have installed the Oracle Client. How can I configure this to connect to the oracle DB. I have IP and SID, also user anme and psw. I am trying to use ODBC to connect.

Please give me some details!
Thanks a lot!
0
 
Einstine98Commented:
see this link if it helps.
http://kb.iupui.edu/data/apaa.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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