SSIS Azure Table Storage Destination

Azure Table Storage Destination can be used to bulk insert large amount of records to Azure Table Storage from any data source using SSIS. Azure Table Storage is a cloud based NoSQL data storage service from Microsoft Azure

Features

Bulk load/write data to Azure Table Storage Table from SSIS dataflow
Interact and write data like a normal table, no need to learn complex APIs
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

Watch this video on YouTube

title="See also" radius="1"]

	Azure Table Storage Source Connector
	Azure Blob Storage Task
	JSON Source Connector (File, REST API)

[/su_box]

ScreenshotsUseful LinksSystem Requirements

Create SSIS Azure Storage Connection – Choose Type

Configure SSIS Azure Table Storage Destination Connection

Configure SSIS Azure Table Storage Destination Adapter – Connection Tab

Configure SSIS Azure Table Storage Destination Adapter – Component Tab

Configure SSIS Azure Table Storage Destination Adapter – Mapping Tab

Execute SSIS Azure Table Storage Destination Adapter – Load Data

SSIS Load Test – View Azure Storage Table Data – Record Count Check

Articles / Tutorials

Click here to see all articles for [SSIS Azure Table Storage Destination] category

How to Read/Write Azure Table Storage data in SSIS

Introduction In our previous blog, we saw how to read/write Azure Blob Storage Files in SSIS (CSV, JSON, XML Format files). Now in this blog, we will see how to Read/Write Azure Table Storage data in SSIS. To illustrate, we will use ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources to multiple destinations like […]