How to migrate data from MySQL to SQL Server using SSIS
Learn how to connect SSIS to MySQL, access and preview your data, and migrate tables from MySQL to SQL Server using SSIS Data Flow Components for MySQL and MariaDB in this beginner-friendly walkthrough!
Timestamps:
0:00 Intro & Overview
0:30 Creating SSIS Project
0:43 Configuring MySQL Connection
1:22 Setting the Destination in SQL Server
2:13 Running SSIS Package & Viewing Migrated Data
👉 Check full overview of SSIS Data Flow Components for MySQL here: https://www.devart.com/ssis/mysql/?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube
🔥 You can download SSIS Data Flow Components for MySQL Trial here: https://www.devart.com/ssis/mysql/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube
💰 You can compare pricing options of SSIS Data Flow Components for MySQL here: https://www.devart.com/ssis/mysql/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 #devart #sqlserver #etl
Closed Caption:
In today's video, we're going to show
you how to connect SSIS to MySQL, access
My Sikfull data, and migrate that data
to Sikfull server. Let's dive in. Here's
the employee data in our My Sikfull
database.
[Music]
As you can see, the table contains five
columns. ID, first name, last name,
city, social security number, and date
of joining. This is the data we'll be
migrating to Sikfull 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 my Sikfell 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 My Sikfull source component
and drag it into the package. Now, it's
time to set up the connection to our My
Sickfull database. In the connection
manager, we'll fill in the following
details. Server, port, user ID, and
password.
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 My
Sickl 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 OLAD
destination component from the toolbox
into the data flow task. Connect the my
sikfull source component to the OLB
destination component. In the Olb
destination, we'll set up a connection
to the Sikville server database. Let's
choose our Sikville server instance and
ensure the credentials are correct.
[Music]
Now we'll create a new table in Sikville
server to store the migrated data.
Next, we'll map the columns from the my
sikfill source to the corresponding
columns in the sikfill server table.
Finally, let's run the SSIS package and
watch the migration in action. Here's
the result in Sikfull server. All rows
from the My Sikfull 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: 02:41
Uploaded By: Devart
Published: 9/10/2025
View Count: 683