How to migrate data from Snowflake to SQL Server using SSIS
Learn how to connect SSIS to Snowflake, access your cloud data warehouse, and load data into SQL Server using Devart SSIS Data Flow Components. This clear, step-by-step guide covers setting up the connection, selecting and previewing Snowflake data, and running smooth, efficient data transfers—all without coding. Ideal for data professionals looking to simplify Snowflake integrations with SSIS.
Timestamps:
0:00 Intro & Overview
0:11 Access Snowflake Customer data
0:42 Creating SSIS project
0:56 Configuring Snowflake connection
1:53 Setting the destination in SQL Server
2:54 Running SSIS package & Viewing migrated data
👉 Check full overview of SSIS Data Flow Components for Snowflake here: https://www.devart.com/ssis/snowflake/?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube
🔥 You can download SSIS Data Flow Components for Snowflake Trial here: https://www.devart.com/ssis/snowflake/download.html?utm_source=youtube&utm_medium=referral&utm_campaign=devart-youtube
💰 You can compare pricing options of SSIS Data Flow Components for Snowflake here: https://www.devart.com/ssis/snowflake/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
#Snowflake #SSIS #DataIntegration #ETL #SQLServer #Devart
Closed Caption:
In today's video, we're going to show
you how to connect SSIS to Snowflake,
access Snowflake data, and migrate that
data to Sikvel server. Let's dive in.
Let's begin by accessing your Snowflake
account to preview the data we'll
migrate. Select the sample database
provided in your environment and then
choose the relevant schema. Within the
schema, locate the customer table to
ensure everything is set up correctly.
Query the customer table to display some
test data.
[Music]
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 Snowflake to Sikfell server to
keep everything clear and organized.
Next, we'll open the data flow task.
From the toolbox, we'll find the Devart
Snowflake source component and drag it
into the package.
In the connection manager, we'll fill in
the following details: domain, user ID,
password, database, and schema.
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 customer table. We'll also
preview the data to confirm we're
accessing the right table.
Everything looks good. Let's move to the
next step. We'll drag the OLED DB
destination component from the toolbox
into the data flow task. Connect the
Snowflake source component to the OI DB
destination component. In the OLED DB
destination, we'll set up a connection
to the Sikfull server database. Let's
choose our Sikfell server instance and
ensure the credentials are correct. Now,
we'll create a new table in Sikfell
server to store the migrated data.
[Music]
[Music]
Next, we'll map the columns from the
Snowflake source to the corresponding
columns in the Sikvel server table.
Finally, let's run the SSIS package and
watch the migration in action. Here's
the result in Sikvel server. All rows
from the Snowflake account 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:08
Uploaded By: Devart
Published: 9/11/2025
View Count: 482