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 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

Download Help File Buy
View All Tasks
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
  • NOTE: This component is not available in SSIS 2005, 2008 and 2008 R2
  • .net framework 4.0 must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2012 or 2014
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2

Download View All Tasks Like This