Sunday 8 April 2018

Download JSON file from Azure Storage and Read it by SSIS – Part 1


Introduction

In this article we are trying to demonstrate how to download a JSON file from Azure Storage and read it by SSIS.

The solution is in two parts.

1.    Download JSON file from AZURRE BLOB Storage.

2.    Read the JSON file and store it in Relational Database Table object.

 

Hope it will be interesting.


Prepare Your SSIS

If we need to connect with AZURE Storage we need SSDT 2014 primarily and with this we need Microsoft SQL Server 2014 Integration Services Feature Pack for Azure.


We can download it from:



When we run the SQL Server 2014 Integration Services Feature Pack, we find the tools to download from Azure Blob Storage.


 

JSON File in Azure Blob Container


 

Download JSON File from Azure BLOB Storage

 

Azure BLOB Storage Account and Key



 

SSIS with Azure Blob Download Task




Azure Blob Download Task Editor




Azure Blob Download Task – Azure Storage Connection



 

Observing JSON File in Local Disk



 

 

Hope you like it. In our next Blog we are moving to " Read the JSON file and store it in Relational Database Table object (Part-2)"






Posted by: MR. JOYDEEP DAS


4 comments:

  1. Thanks for sharing your information, Get more knowledge on Azure Online Training Bangalore

    ReplyDelete
  2. Is it okay to post part of this on my website basically post a hyperlink to this webpage?
    mobile back cover

    ReplyDelete
  3. Sometime few educational blogs become very helpful while getting relevant and new information related to your targeted area. As I found this blog and appreciate the information delivered to my database.
    เช่าที่เก็บของ

    ReplyDelete
  4. Pengertian Correct Score Sbobet atau Tebak Skor adalah salah satu jenis taruhan yang sangat menguntungkan selain mix parlay. Dikarenakan perkalian Odds / Hadiah Taruhannya yang sangat besar sehingga banyak menarik perhatian para pecandu Judi Bola. Tak hanya itu, dari sistem bermain pun sangatlah gampang karena (Baca Selengkapnya Disini...)

    ReplyDelete