Category Archives: SSIS Template Transform

Create new Amazon DynamoDB Connection in SSIS - Use Amazon DynamoDB Execute SQL Task - List Tables Example

How to Read / Write Amazon DynamoDB in SSIS

Posted on by

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

JSON File Destination - Generate JSON in SSIS from multiple inputs

5 Ways to Export JSON from SQL Server using SSIS

Posted on by

Introduction SQL Server 2012 and all previous versions lacking native JSON support, same theory is true for their ETL Platform SSIS. If you are one of them who wants to export JSON from SQL Server or any other RDBMS like MySQL, Oracle then you can easily output complex JSON using any of the following components. Five ways of […]