SSIS Azure Table Storage Source

Azure Table Storage Source can be used to extract large amount of data from Azure Table Storage. This component supports SQL like query language to query Azure Table Storage data without worrying about complex API. Azure Table Storage is a cloud based NoSQL data storage service from Microsoft Azure

Features

Bulk extract/output Azure Table Storage data
Support for SQL Like queries using proprietary Query engine, no need to learn complex Azure APIs
Support for data preview
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 Destination Connector
	Azure Blob Storage Task
	JSON / REST API Source
	Azure Blob Source for CSV Files
	Azure Blob Destination for CSV Files
	Azure Queue Storage Source
	Azure Queue Storage Destination

[/su_box]

ScreenshotsUseful LinksSystem Requirements

SSIS Azure Table Storage Source Adapter Settings

Configure SSIS Azure Table Storage Source Connection

Configure SSIS Azure Table Storage Source Table Data Preview

Configure SSIS Azure Table Storage Source SQL Query Data Preview

Configure SSIS Azure Table Storage Source Sample Execution

Articles / Tutorials

Click here to see all articles for [SSIS Azure Table Storage Source] 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 […]