SSIS Amazon Redshift ExecuteSQL Task (AWS Redshift Datawarehouse)

Step-By-Step

In this tutorial you will learn how to create Table and Delete if Exist.

Firstly, You need to Download and Install SSIS ZappySys PowerPack.

Once you finished first step, Open Visual Studio and Create New SSIS Package Project.

Here, In Visual Studio, drag and drop the Amazon Redshift ExecuteSQL Task in the design surface.
SSIS Amazon Redshift ExecuteSQL Task - Drag and Drop

SSIS Amazon Redshift ExecuteSQL Task - Drag and Drop

Now we need Amazon Redshift Connection. Click here to Create Amazon Redshift Connection.

Double click on Amazon Redshift ExecuteSQL Task to configure it.

Select Connection we have created before, set Sql Source Type to DirectValue, Result Type to FullResultSet and Select Object Variable and Use Following SQL Query for Amazon Redshift.
SSIS Execute SQL Query - Amazon Redshift

SSIS Execute SQL Query - Amazon Redshift

Click on OK button to save configure setting UI.

Thats all, you can run or Execute your package.
SSIS Amazon Redshift ExecuteSQL Task - Run or Execute

Properties

Property Name	Description
ResultsetType	ResultSet Type. It can be None, FullResultset or SingleValue. When FullResultset is specified then you have to store result in Object type variable. Full result is ADO.net DataTable. SingleValue is Object datatype
ResultsetVariable	Variable name which will store Full resultset (ADO.net DataTable) or single value of result. Variable type must be object datatype if storing full resultset
SqlStatementSourceType	Source of SQL Statement. It can be DirectValue or Variable
Timeout	Command timeout in second. 0 means no command timeout
SqlStatementSource	If SqlSourceType=DirectValue then this property holds SQL Query. SqlSourceType=Variable then this property holds Variable name which holds SQL Query
Connection	Redshift Connection where you want to execute sql command
LoggingMode	LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log.

Property Name

Description

ResultsetType

ResultSet Type. It can be None, FullResultset or SingleValue. When FullResultset is specified then you have to store result in Object type variable. Full result is ADO.net DataTable. SingleValue is Object datatype

ResultsetVariable

Variable name which will store Full resultset (ADO.net DataTable) or single value of result. Variable type must be object datatype if storing full resultset

SqlStatementSourceType

Source of SQL Statement. It can be DirectValue or Variable

Timeout

Command timeout in second. 0 means no command timeout

SqlStatementSource

If SqlSourceType=DirectValue then this property holds SQL Query. SqlSourceType=Variable then this property holds Variable name which holds SQL Query

Connection

Redshift Connection where you want to execute sql command

LoggingMode

LoggingMode determines how much information is logged during Package Execution. Set Logging mode to Debugging for maximum log.

Introduction ZappySys provide high-performance drag and drop connectors for Amazon Redshift Integration. In previous post we saw how to read / write Amazon Redshift data in SSIS. Now in this post, you will see how to Execute SQL query against Amazon Redshift in SSIS using ZS Amazon Redshift ExecuteSQL Task.Â SSIS Redshift Execute SQL TaskÂ can be […]

Content

Video Tutorial

Step-By-Step

Properties

Setting UI

See Also

Articles / Tutorials

Execute SQL query against Amazon Redshift in SSIS