Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This document focuses on how to export data from and load data into Oracle data database using the SSIS ADO.NET source and ADO.NET Destination components. An ADO.NET connection manager allows a package to access data sources with a .NET provider, specifically the OracleClient Data Provider.
Here are the main steps.
First, download the latest Oracle Client for Microsoft Tools and install Oracle client.
Note
Installing both 32-bit and 64-bit versions together may cause compatibility issues. Install only one version.
For details, see ADO.NET connection manager.
Export data using the ADO NET source. For details, see ADO NET Source.
Use ADO NET destination loads data into ADO.NET-compliant databases. For details, see ADO NET Destination.
Note
ADO.NET allows packages to access data sources with the .NET OracleClient Data Provider. When migrating from Microsoft's connector for Oracle, custom properties in Oracle source and Oracle destination components set by Advanced Editor only aren't available in ADO.NET source and destination.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Load data into a Microsoft Fabric data warehouse - Training
Explore the process of loading data into a warehouse in Microsoft Fabric.