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

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 […]