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
Thanks for sharing your information, Get more knowledge on Azure Online Training Bangalore
ReplyDeleteIs it okay to post part of this on my website basically post a hyperlink to this webpage?
ReplyDeletemobile back cover
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เช่าที่เก็บของ
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