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