Oracle Provider for ssis
-
Thursday, January 17, 2013 12:24 PM
Hi
i am using SSIS in project..i want to use oracle 11g as a target db so i uninstall oracle 10g and i went to regedit delete some files related to 10g but unfortunately i loss oracle provider in SSIS
How to get back oracle provider in SSIS where i want to download that for ssis
All Replies
-
Thursday, January 17, 2013 12:30 PM
-
Thursday, January 17, 2013 12:46 PM
Where to download that Oracle OleDB Provider whether it il available in Microsoft site
Any download link is there plz provide
-
Thursday, January 17, 2013 12:54 PM You can get the Oracle provider from Oracle and not from Microsoft, of course: http://www.oracle.com/technetwork/database/windows/utilsoft-088126.html
Olaf Helper
Blog Xing- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, January 24, 2013 2:03 AM
-
Thursday, January 17, 2013 1:22 PM
Once you have the oracle provider (usually loaded by installing the Oracle client) Then you may also want to download the Microsoft connectors for oracle if you are using enterprise edition on your prod servers. These provide faster reading and writing to Oracle than the standard ssis data source/destinations.
2012 version http://www.microsoft.com/en-us/download/details.aspx?id=29283
2008 version http://www.microsoft.com/en-us/download/details.aspx?id=29284
Chuck Pedretti | Magenic – North Region | magenic.com
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, January 24, 2013 2:03 AM
.png)
