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
- Control Flow Task in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial

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,DeleteTableCreateTableSafe/DeleteTableSafeskip the error if the table exists or is missing- Define keys, local and global secondary indexes and read/write throughput
Insert, update & delete items
Run DML commands against DynamoDB items.
PutItem,UpdateItem,DeleteItemBatchInsertandBatchDeleteQuerycommand to select items
List & describe tables
Get the list of tables or table details such as row count and size.
ListTablesandDescribeTablePropertyFilter(JSON path, e.g.Table.ItemCount) returns a single attribute
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
Flexible result types
Save the command response into an SSIS variable.
RawResult: the JSON responseSingleValue: e.g. a count or sizeFullResultset: ADO.net DataTable for a ForEach Loop
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
Statement from variable
Type the statement directly or read it from an SSIS variable.
SqlStatementSourceType: DirectValue or VariableTimeoutin seconds (0 = no timeout)
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
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)
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
SQL Server 2012–2025
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.

Connect with the Amazon Storage Connection Manager
Add a ZS-AWS-Storage connection, select DynamoDB as the storage service and enter your access key and secret key, then click Test Connection.
For testing without an AWS account, check the DynamoDB Local option to use the free local emulator.

Run with Test / Preview
Pick a command from the Examples dropdown (for example List Tables) to start from a working request.
Click Test / Preview to run it and see the response, or click OK and execute the package. Save the result to a variable as RawResult (JSON), SingleValue or FullResultset.

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.
Articles
Worked examples that use Amazon DynamoDB ExecuteSQL Task.
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.
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.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.