SSIS Amazon DynamoDB ExecuteSQL Task

Amazon DynamoDB ExecuteSQL Task can be used to execute ad-hoc commands for Amazon DynamoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.)

Features

  • Intuitive user interface with many examples makes DynamoDB learning super easy and fast
  • Support for executing DDL statements such as Create/Drop table
  • Support for executing DML statements such as Select/Insert/Update/Delete
  • Support for saving RawResult (e.g. JSON response) into SSIS variable
  • Support for saving SingleValue from response such as count or size from getStats function response.
  • Support for saving FullResultset as ADO.net dataset (e.g. select * from mytable) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).
See also
Custom SSIS Components - Amazon DynamoDB Destination (AWS DynamoDB Bulk Insert/Delete) Amazon DynamoDB Destination
Custom SSIS Components - Amazon S3 Task (AWS S3) Amazon S3 Task
Custom SSIS Components - Amazon Redshift Data Transfer Task (AWS Redshift) Amazon Redshift Data Transfer 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

In Visual Studio, from SSIS Toolbox drag and drop the ZS Amazon DynamoDB ExecuteSql Task

Drag and drop the ZS Amazon DynamoDB ExecuteSql Task

Drag and drop the ZS Amazon DynamoDB ExecuteSql Task

Right click on Connection Managers Panel to Create New Connection from the Context Menu.

Create New Connection

Create New Connection

Select ZS-AWS-Storage Connection Manager from the Connection Managers list and Click on Add Button

Select ZS-AWS-Storage Connection Manager

Select ZS-AWS-Storage Connection Manager

Enter credentials and Click on Test Connection

Enter Credentials and Click on Test Connection

Enter Credentials and Click on Test Connection

How to Create Table using Amazon DynamoDB ExecuteSQL Task, Double Click on it to Configure it.

Amazon DynamoDb ExecuteSQL Task to configure it

Amazon DynamoDb ExecuteSQL Task to configure it

Finally, you can run by press Test / Preview button or hit on OK button and Execute Package

You can run by press Test / Preview button

You can run by press Test / Preview button

 

Articles / Tutorials


How to Read / Write Amazon DynamoDB in SSIS

How to Read / Write Amazon DynamoDB in SSIS

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

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