How to migrate data from Oracle to SQL Server using SSIS

How to migrate data from Oracle to SQL Server using SSIS


Learn how to connect SSIS to Oracle, access and preview your data, and migrate tables from Oracle to SQL Server using SSIS Data Flow Components for Oracle in this beginner-friendly walkthrough!

Timestamps:
0:00 Intro & overview
0:25 Creating SSIS project
0:43 Configuring Oracle connection
1:43 Setting the destination in SQL Server
2:30 Running SSIS package & Viewing migrated data

👉 Check full overview of SSIS Data Flow Components for Oracle here: https://www.devart.com/ssis/oracle/?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube

🔥 You can download SSIS Data Flow Components for Oracle Trial here: https://www.devart.com/ssis/oracle/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube

💰 You can compare pricing options of SSIS Data Flow Components for Oracle here: https://www.devart.com/ssis/oracle/ordering.html?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube

👉 Check full overview of SSIS Data Flow Components here: https://www.devart.com/ssis/?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube

#ssis #datamigration #oracle #devart #sqlserver #etl
Closed Caption:

In today's video, we're going to show
you how to connect SSIS to Oracle,
access Oracle data, and migrate that
data to Sikfell server. Let's dive in.
Here's the employee data in our Oracle
database. As you can see, the table
contains five columns. ID, first name,
last name, date of joining, and salary.
This is the data we'll be migrating to
Sikville server using SSIS. Now, let's
set up an SSIS project. We'll start by
dragging a data flow task onto the
control flow surface. Let's rename it to
migrate data from Oracle to Sikfull
server to keep everything clear and
organized.
Next, we'll open the data flow task.
From the toolbox, we'll find the Devart
Oracle source component and drag it into
the package.
Now, it's time to set up the connection
to our Oracle database.
In the connection manager, we'll fill in
the following details: server, port,
user ID, and password. If you're using a
service name, you can enter that in the
advanced settings.
Once the details are filled in, test the
connection to ensure everything is set
up correctly. As you can see, the
connection is successful. Now, let's
choose the employee table from our
Oracle database. We'll also preview the
data to confirm we're accessing the
right table.
Everything looks good. Let's move to the
next step. Let's configure the
destination in our Sikfull server
database. We'll drag the OLB destination
component from the toolbox into the data
flow task. Connect the Oracle source
component to the OLADB destination
component. This creates the data flow
path from Oracle to Sikfull server. In
the OLB destination, we'll set up a
connection to the Sikfull server
database. Let's choose our Sikfull
server instance and ensure the
credentials are correct.
Now we'll create a new table in Sikfull
server to store the migrated data.
Next, we'll map the columns from the
Oracle source to the corresponding
columns in the Sikfull server table.
Finally, let's run the SS package and
watch the migration in action.
[Music]
[Music]
Here's the result in Sikfull server. All
10 rows from the Oracle employee table
have been successfully migrated.
Thank you for watching this tutorial. We
hope you found it helpful. Feel free to
share the video with anyone who might
benefit from

Video Length: 03:03
Uploaded By: Devart
Published: 9/10/2025
View Count: 1,263

Related Software Products
SSIS Data Flow Components for Oracle
SSIS Data Flow Components for Oracle

Published By:
Devart

Description:
SSIS Data Flow Components for Oracle: Oracle Source, Destination and Lookup for SSIS, No Oracle Client Needed SSIS Data Flow Components for Oracle is Devart's Oracle connector for SQL Server Integration Services: an Oracle Source, Oracle Destination, Oracle Lookup and an Oracle Connection Manager that can reach the database directly over TCP/IP without installing Oracle Client. It's for data engineers and DBAs who move data between Oracle and SQL...

Copyright © 2026, Ivertech. All rights reserved.