![]() SSIS DynamoDB DestinationAmazon DynamoDB Destination can be used to bulk insert large amount of records to Amazon DynamoDB storage from any data source using SSIS. Amazon DynamoDB is a cloud based NoSQL data storage service from Amazon AWS Features
|
|
Download Help File Buy | View All Tasks |
From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.

From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.
Create new Amazon DynamoDB connection

Create SSIS Amazon Storage Connection for DynamoDB
Configure Amazon Storage Connection for DynamoDB

Configure SSIS Amazon DynamoDB Destination Connection
Select Amazon Storage Connection

Configure SSIS Amazon DynamoDB Destination Adapter – Connection Tab
Configure Amazon DynamoDB Target settings

Configure SSIS Amazon DynamoDB Destination Adapter – Component Tab
Insert nested JSON documents to Amazon DynamoDB from multiple inputs

Amazon DynamoDB Data Load – Inserting Raw JSON Document
Simple Mapping Mode (Map Individual Columns rather than Raw JSON document Load)

Configure SSIS Amazon DynamoDB Destination Adapter – Mapping Tab
Update DynamoDB Documents in SSIS Data Flow

Update Amazon DynamoDB Documents
Loading data into Amazon DynamoDB in SSIS Data Flow

Execute SSIS Amazon DynamoDB Destination Adapter – Load Data
Articles / Tutorials
How to Read / Write DynamoDB data in SSIS (Query, Insert, Update, Delete)
How to Read / Write Amazon DynamoDB in SSISIntroduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source […] |