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
