Import your ‘On-Prem’ Data to Azure SQL Data Warehouse by SSIS

Introduction

We have already discussed many ways to import data in Azure DWH. Today I will discuss 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 etc…

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 Data Flow pane

Azure

Attendance Code Source is Data Flow Components

Azure

Give details of your Server and Table after Double Clicking Attendance Code Source,

Azure

 

Azure

You could click on the table to Preview Data,

Azure

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

Azure

At Destination Editor, You need to give Azure Data Warehouse Name at connection manager, You could find it after Login at your Azure Portal and Clicking at Azure Data Warehouse as highlighted below,

Azure
Azure

 

Azure

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

Please note GREEN Color reflect successful run.

Azure

Hope this will be helpful, until next time happy coding!!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s