Let's Import Data To Azure SQL Data Warehouse Using SSIS

We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import data from different data sets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2 .

Introduction

We have already discussed many ways to import data in Azure DWH. Today, I will discuss an OLD SCHOOL approach of importing data by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import the data from different datasets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2, and more. 

Prerequisite

  • Azure Subscription.
  • Azure SQL Server and an Azure Data Warehouse Database
  • SQL Server Data Tools with SSIS installed
  • Visual Studio 2015 - Visual Studio 2013

Let’s start!

FYI,  I’m using  VS 2015.

 

Azure

 

Go to File>New project and select Integration Services Project.

 

Azure

 

Add ‘Data Flow Task’ as shown below.

 

Azure

 

Double click in Data Flow Task; it will open the Data Flow pane.

 

Azure

 

Attendance Code Source is in Data Flow Components.

Azure

Give details of your Server and Table after double clicking Attendance Code Source.

Azure

Azure

 

  1. You can click on the table to Preview the data.

 

Azure

Here, I’m only inserting the New Rows at Lookup Editor.

Azure

At Destination Editor, you need to give Azure Data Warehouse a name at connection manager. You can find it after you login to your Azure Portal and by clicking Azure Data Warehouse as highlighted below.

 

Azure

 

Azure

Azure

After this, click F5 or Run and your SSIS package will execute.

Please note GREEN  indicates a successful run.

Azure

I hope this will be helpful. Until next time, happy coding!!