?
Solved

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

Posted on 2008-10-16
3
Medium Priority
?
2,912 Views
Last Modified: 2013-11-11
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
Comment
Question by:johnyue
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Einstine98
ID: 22735076
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
 

Author Comment

by:johnyue
ID: 22735128
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
 
LVL 12

Accepted Solution

by:
Einstine98 earned 2000 total points
ID: 22735155
see this link if it helps.
http://kb.iupui.edu/data/apaa.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question