SSIS Azure Table Storage Destination Adapter - NoSQL Connector

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
See also
Custom SSIS Components - Azure Table Storage Source Connector Azure Table Storage Source Connector
Custom SSIS Tasks - Azure Blob Storage Task Azure Blob Storage Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Download Help File Buy View All Tasks
ScreenshotsUseful LinksSystem Requirements

Create SSIS Azure Storage Connection – Choose Type

Create SSIS Azure Storage Connection - Choose Type

Create SSIS Azure Storage Connection – Choose Type

Configure SSIS Azure Table Storage Destination Connection

Configure SSIS Azure Table Storage Destination Connection

Configure SSIS Azure Table Storage Destination Connection

Configure SSIS Azure Table Storage Destination Adapter – Connection Tab

Configure SSIS Azure Table Storage Destination Adapter - Connection Tab

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 - Component Tab

Configure SSIS Azure Table Storage Destination Adapter – Component Tab

Configure SSIS Azure Table Storage Destination Adapter – Mapping Tab

Configure SSIS Azure Table Storage Destination Adapter - Mapping Tab

Configure SSIS Azure Table Storage Destination Adapter – Mapping Tab

Execute SSIS Azure Table Storage Destination Adapter – Load Data

Execute SSIS Azure Table Storage Destination Adapter - Load Data

Execute SSIS Azure Table Storage Destination Adapter – Load Data

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

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

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

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

Azure Table Storage Destination FAQs

Click here to learn more about System Requirements
Download View All Tasks Like This