Monthly Archives: March 2018

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

Learn Chat bot application using Microsoft Bot Framework and Secure Cloud Azure Storage 

Learn Chat bot application using Microsoft Bot Framework and Secure Cloud Azure Storage“.

Sat, Mar 24, 2018 10:00 AM – 12:00 PM CDT  / 9 AM Saskatchewan Time. 

Where: Online

Price: Free of cost

Event URL: https://global.gotomeeting.com/join/776269525

Note: There are 100 seats only. First come first serve.

Details of Event

Learn Chat bot application using Microsoft Bot Framework – Rahat Yasir

• Why Chat Bot

• How to Develop

• Accelerated development

• Q&A

Unboxing Secure Cloud Azure Storage – Deepak Kaushik

• Brief Introduction to Azure Storage

• Scenarios / Working with Blob Storage

• Key Concepts / Architecture

• Q&A
Please join my meeting from your computer, tablet or smartphone. 
https://global.gotomeeting.com/join/776269525 

You can also dial in using your phone. 
Canada: +1 (647) 497-9373 

Access Code: 776-269-525 

Before and after MVP Global Summit 2018

Being back at home and work, I wanted to convey my thanks to Microsoft for organizing such awesome events as #MSSummit at Seattle. I feel fortunate enough to meet industry legends and phenomenal figures. I learned fundamentals of the Technologies by *Following, Listening and Reading* from these legends.

I have mesmerizing memories to meet  Scott Hanselman, Mahesh Chand, Jen Stirrup, Magnus Mårtensson , DJ, AzureAdvocates and many more.

I’ve learned many new things and earned so many friends/connection here @ #MVPSummit 

Special thanks and gratitude to Microsoft Canada Community Program Manager,  Simran Chaudhry , you are the Best Lead Simran, Bundle of Love and Respect!!

Thank you Patrick Malone and team for MVPGlobalSummit, I’m  #ProudToBeMVP

Looking forward to meet you all very soon !! #CDNMVP #MVPBuzz  

Here is some of Treasures from my sweet memories :-

 

 

MVP Global Summit 2018

MVP Summit

I’m super excited to attend  Microsoft MVP Global Summit  in March 1st week.

MVPs from around the world meet on Bellevue, Redmond, and Seattle, Washington for several days of technical sessions on the Microsoft campus.

Thank you Microsoft for providing *Great Award* and having me to the MVP party.

I’ll continue to endeavor to be worthy of your trust and acknowledgement.

Looking forward to see you all fellow MVPs.