Included in SSIS PowerPack

SSIS Amazon DynamoDB ExecuteSQL Task

Execute ad-hoc commands for Amazon DynamoDB: create, update or delete tables and insert, update, delete or query items.

Amazon DynamoDB ExecuteSQL Task runs ad-hoc commands against Amazon DynamoDB: DDL commands such as create, update and delete table, and DML commands such as put, update and delete items, batch insert and batch delete, query, list tables and describe table.

The trial includes Amazon DynamoDB ExecuteSQL Task and every other PowerPack component

SSIS Amazon DynamoDB ExecuteSQL Task configured with a create table request
Run a DynamoDB command such as creating a table

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Amazon DynamoDB ExecuteSQL Task can do

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.)

Create, update & drop tables

Run DDL commands to create, change and delete DynamoDB tables.

  • CreateTable, UpdateTable, DeleteTable
  • CreateTableSafe / DeleteTableSafe skip the error if the table exists or is missing
  • Define keys, local and global secondary indexes and read/write throughput

Component help

Insert, update & delete items

Run DML commands against DynamoDB items.

  • PutItem, UpdateItem, DeleteItem
  • BatchInsert and BatchDelete
  • Query command to select items

Component help

List & describe tables

Get the list of tables or table details such as row count and size.

  • ListTables and DescribeTable
  • PropertyFilter (JSON path, e.g. Table.ItemCount) returns a single attribute

Component help

Wait until table is active

Use the Wait option so the task waits until the table operation is done.

  • Example: wait until table status is ACTIVE after create or throughput change

Component help

Flexible result types

Save the command response into an SSIS variable.

  • RawResult: the JSON response
  • SingleValue: e.g. a count or size
  • FullResultset: ADO.net DataTable for a ForEach Loop

Component help

Examples & test preview

An intuitive UI with many examples makes DynamoDB commands easy to learn.

  • Pick a command from the Examples dropdown
  • Run it with the Test / Preview button before saving

Read / write DynamoDB guide

Statement from variable

Type the statement directly or read it from an SSIS variable.

  • SqlStatementSourceType: DirectValue or Variable
  • Timeout in seconds (0 = no timeout)

Component help

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

AWS & DynamoDB Local

Connect through the Amazon Storage Connection Manager with DynamoDB as the service type.

  • Access key and secret key, temporary token or default (IAM role) credentials
  • DynamoDB Local option for the free local emulator (see the read / write DynamoDB guide)

Connection Manager help

See all features
  • Execute ad-hoc commands for Amazon DynamoDB
  • DDL statements such as create, update and delete table
  • Safe variants that do not fail if the table already exists or is not found
  • DML statements such as insert (put), update and delete items, plus batch insert and batch delete
  • List tables and get table details such as row count and size
  • Wait until the table operation is done (e.g. table status ACTIVE)
  • Save the raw JSON response into an SSIS variable
  • Save a single value from the response, such as a count or size
  • Save a full result set as an ADO.net DataTable for a ForEach Loop
  • Intuitive UI with many examples and a Test / Preview button
  • Read the statement from a direct value or an SSIS variable
  • Connect to AWS or to DynamoDB Local for testing
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Amazon DynamoDB ExecuteSQL Task page and help file, with the screens you will see in SSDT.

Create a DynamoDB table

Double-click the task, select the connection, set SQL Source type to DirectValue and CommandType to CreateTable.

Enter the request as JSON: table name, attribute definitions, key schema (HASH / RANGE) and provisioned throughput. Add Wait: true to wait until the table status is ACTIVE.

Amazon DynamoDB ExecuteSQL Task - CreateTable request

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Amazon DynamoDB ExecuteSQL Task product page. Step through them, or open any shot at full size.

Drag and drop the Amazon DynamoDB ExecuteSQL Task

From the SSIS Toolbox, drag the ZS Amazon DynamoDB ExecuteSQL Task onto the Control Flow and double-click it to configure.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Amazon DynamoDB ExecuteSQL Task on the canvas.

What is Amazon DynamoDB ExecuteSQL Task?

Amazon DynamoDB ExecuteSQL Task runs ad-hoc commands for Amazon DynamoDB from the SSIS Control Flow: DDL such as create, update and delete table, and DML such as put, update and delete items, batch insert, batch delete and query.

What can Amazon DynamoDB ExecuteSQL Task do?

Pick a CommandType (CreateTable, CreateTableSafe, UpdateTable, DeleteTable, DeleteTableSafe, PutItem, UpdateItem, DeleteItem, BatchInsert, BatchDelete, Query, ListTables or DescribeTable) and enter the request as JSON, or start from the Examples dropdown. The response can be saved to an SSIS variable as RawResult (JSON), SingleValue (for example a count or size) or FullResultset (ADO.net DataTable for a ForEach Loop).

Can I avoid errors when a table already exists or is missing?

Yes. CreateTableSafe ignores the command if the table already exists, and DeleteTableSafe ignores it if the table is not found. Add Wait: true to wait until the operation finishes and the table is ACTIVE.

Can I test without an AWS account?

Yes. Run the free DynamoDB Local emulator and check the DynamoDB Local option on the Amazon Storage Connection Manager. See How to Read / Write Amazon DynamoDB in SSIS.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Amazon DynamoDB ExecuteSQL Task onto the Control Flow.

Execute ad-hoc commands for Amazon DynamoDB: create, update or delete tables and insert, update, delete or query items.

  • Control Flow Task in SSISAmazon DynamoDB ExecuteSQL Task appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 5