In Visual Studio, from SSIS Toolbox drag and drop the ZS Amazon DynamoDB ExecuteSql Task
Right click on Connection Managers Panel to Create New Connection from the Context Menu.
Select ZS-AWS-Storage Connection Manager from the Connection Managers list and Click on Add Button
Enter credentials and Click on Test Connection
How to Create Table using Amazon DynamoDB ExecuteSQL Task, Double Click on it to Configure it.
Finally, you can run by press Test / Preview button or hit on OK button and Execute Package
Articles / Tutorials
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 […]