![]() SSIS Redshift Execute SQL TaskSSIS 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.
|
![]() |
|||
|
View All Tasks Like This |
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 SSISIntroduction 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 […] |
See Also
Articles/Posts

MySQL to Redshift Data Load Using SSIS
Contents1 Introduction – MySQL to Redshift Load2 Video Tutorial3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift Database?4.2 Command line approach for MySQL to Redshift data loading5 Setup your Amazon Redshift Cluster6 […]