SSIS Redshift Execute SQL Task

SSIS Redshift Execute SQL Task can be used to send any sql queries to Redshift Cluster without needing ODBC driver. You can Issue various sql commands such as DROP, COPY, UNLOAD, CREATE etc.

Allows to execute queries against Amazon Redshift Cluster without ODBC driver
Load query at runtime from variable, file or Direct value
100% Managed code means its 32bit and 64bit compatible
You can issue COPY, UNLOAD commands very easily
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: Amazon Redshift related articles

In Visual Studio, drag and drop the Amazon Redshift ExecuteSQL Task in the design surface

Drag and drop the Amazon Redshift ExecuteSQL Task

Create and Configure Amazon Redshift Connection

Create new Amazon Redshift Connection in SSIS

How to Create Table using Amazon Redshift ExecuteSQL Task

Create Table By SQL Query in Amazon Redshift using Amazon Redshift ExecuteSql Task

That’s all, you can run or Execute your package

Run or Execute your package

Articles / Tutorials

How to Read / Write DynamoDB data in SSIS (Query, Insert, Update, Delete)

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

Articles/Posts

MySQL to Redshift Data Load Using SSIS

Posted: June 29, 2015

Introduction – MySQL to Redshift Load Before we talk about data load from MySQL to Redshift using SSIS, first lets talk what is Amazon Redshift (or AWS Redshift). Amazon Redshift is a Cloud based Data warehouse service. This type of system also referred as MPP (Massively Parallel Processing). Amazon Redshift uses highly modified version of […]