29117

SSIS 2008 Oracle Connectivity

I have tried to connect to Oracle DB using OLE DB Source ie <strong>Microsoft OLE DB Provider for Oracle</strong>. I am able to connect. But when I clicked on Preview button in OLE DB Source, I received a warning message before previewing.Please see below :

<img src="https://i.stack.imgur.com/VQnXE.jpg" alt="Oracle Source using OLE DB Provider for Oracle warning message">

I am able to preview except this warning message. Which provider should we have to use for connecting Oracle ? <strong>Microsoft OLE DB Provider for Oracle</strong> or <strong>Oracle Provider for OLE DB</strong> ?

Answer1:

To use the original provider, you simply need to specify the code page. I had the same issue. for the connections for Oracle, I had to set the AlwaysUseDefaultCodePage = True

See the image here: Data Flow Component Properties

For instructions on how to set this, look here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dc1a61f2-1ab8-4ed3-b85c-db6481800b50/

See Jamie Thomson's answer and the one after it. They speak of the always use default code page option and explain how to find it and how to set it.

You might also try the Attunity connector for Oracle. I have never used this one, but I have heard great things about it and it is supposed to be very fast:

http://www.microsoft.com/en-us/download/details.aspx?id=29284

Recommend

  • detecting connection lost in spark streaming
  • New-PSSession in an Azure-runbook (ARM)
  • limited threads in soapUI free version
  • HikariPool-1 - Unusual system clock change detected, soft-evicting connections from pool
  • qt how to know that a pushbutton is clicked?
  • Can't connect Entity Framework to local SQL Server Express
  • Run script file on remote server
  • how to read a file in prolog?
  • Streaming screenshots over WebRTC as a video stream from iOS
  • Runtime.exec() gives Error: Could not find or load main class
  • quiver not drawing arrows just lots of blue, matlab
  • Who propagate bugfixes across branches (corporate development)?
  • xcode don't localize specific strings
  • Does Mobilefirst provide a provision to access web services directly?
  • WPF ICommand CanExecute(): RaiseCanExecuteChanged() or automatic handling via DispatchTimer?
  • How solve “Qt: Untested Windows version 10.0 detected!”
  • How can I enlarge video fullscreen without the affected interface project in as3?
  • Typescript - Unable to get 'import' statement to function
  • ilmerge with a PFX file
  • Disabling Alt-F4 on a Win Forms NotifyIcon
  • Display issues when we change from one jquery mobile page to another in firefox
  • Different response to non-authenticated users and AJAX calls
  • Updating server-side rendering client-side
  • Javascript Callbacks with Object constructor
  • htaccess rewriting URLs with multiple forward slashes
  • Arrow is showed instead of the material design version hamburger icon. Why doesn't syncState in
  • How can I use Kendo UI with Razor?
  • Display Images one by one with next and previous functionality
  • Web-crawler for facebook in python
  • Data Validation Drop Down Box Arrow Disappearing
  • A cron job substitute?
  • Acquiring multiple attributes from .xml file in c#
  • How to set the response of a form post action to a iframe source?
  • How to CLICK on IE download dialog box i.e.(Open, Save, Save As…)
  • Change div Background jquery
  • Qt: Run a script BEFORE make
  • How can I remove ASP.NET Designer.cs files?
  • Running Map reduces the dimensions of the matrices
  • reshape alternating columns in less time and using less memory
  • java string with new operator and a literal