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.
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.