SSIS Amazon Redshift ExecuteSQL Task
Send any SQL query to an Amazon Redshift cluster without needing an ODBC driver.
SSIS Redshift Execute SQL Task sends any SQL query to an Amazon Redshift cluster without needing an ODBC driver. You can issue SQL commands such as DROP, COPY, UNLOAD and CREATE.
The trial includes Amazon Redshift ExecuteSQL Task and every other PowerPack component
- Control Flow Task in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial

At a glance
What Amazon Redshift ExecuteSQL Task can do
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.
No ODBC driver needed
Send SQL queries to an Amazon Redshift cluster without an ODBC driver.
- 100% managed code, so it works in 32-bit and 64-bit
Any Redshift SQL command
Issue SQL commands such as CREATE, DROP, COPY and UNLOAD.
- Example: drop a table if it exists, then create it
SQL from text or a variable
Type the SQL directly in the task, or load it at runtime from an SSIS variable.
SqlStatementSourceType: DirectValue or VariableSqlStatementSourceholds the SQL text or the variable name
Results into variables
Store query results in an SSIS variable for later steps in the package.
ResultsetType: None, FullResultset or SingleValue- FullResultset is an ADO.net DataTable stored in an Object variable
Timeout & logging
Control command timeout and how much is logged.
Timeoutin seconds (0 = no timeout)LoggingMode: set Debugging for maximum log
Secure Redshift connection
Connect with host, port, database, user name and password through the Amazon Redshift Connection Manager.
- Enable SSL
- X509 client certificate from the LocalMachine or CurrentUser store, or a PFX or PEM file
Connection performance
Tune how the connection behaves while the package runs.
- Connection pooling
RetainSameConnectionkeeps one connection open for multiple tasks- Separate command and connect timeouts
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
See all features
- Execute queries against an Amazon Redshift cluster without an ODBC driver
- Issue SQL commands such as DROP, COPY, UNLOAD and CREATE
- Type the SQL directly or load it at runtime from an SSIS variable
- Store a full result set (ADO.net DataTable) or a single value in an SSIS variable
- Command timeout setting (0 = no timeout)
- 100% managed code, compatible with 32-bit and 64-bit
- SSL and X509 client certificate support on the Amazon Redshift Connection Manager
- Connection pooling and
RetainSameConnectionto share one open connection across tasks - Logging modes up to Debugging for maximum log
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Key steps from the Amazon Redshift ExecuteSQL Task page and help file, with the screens you will see in SSDT.
Create and Configure Amazon Redshift Connection
Right-click the Connection Managers panel, choose New Connection and pick ZS-REDSHIFT.
Enter the host, database, user name and password (tick Enable SSL if needed) and click Test Connection.

Create a table with a SQL query
Double-click the task, select the Redshift connection, set Sql Source Type to DirectValue and enter your SQL, for example DROP TABLE IF EXISTS CustomerData; followed by a CREATE TABLE statement.
To keep results, set Result Type to FullResultSet or SingleValue and pick an Object variable. Then run the task to execute the SQL in Redshift.

Amazon Redshift ExecuteSQL Task – Properties
Key properties: Connection, SqlStatementSourceType (DirectValue or Variable), SqlStatementSource, ResultsetType (None, FullResultset or SingleValue), ResultsetVariable and Timeout in seconds (0 means no timeout).

Inside the UI
Key settings, as they appear in SSDT.
Real screens from the Amazon Redshift ExecuteSQL Task product page. Step through them, or open any shot at full size.
Drag and drop the Amazon Redshift ExecuteSQL Task
In Visual Studio, drag and drop the Amazon Redshift ExecuteSQL Task onto the Control Flow design surface.
Articles
Worked examples that use Amazon Redshift ExecuteSQL Task.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop Amazon Redshift ExecuteSQL Task on the canvas.
What is Amazon Redshift ExecuteSQL Task?
SSIS Redshift Execute SQL Task sends any SQL query to an Amazon Redshift cluster without needing an ODBC driver. You can issue SQL commands such as DROP, COPY, UNLOAD and CREATE.
What can Amazon Redshift ExecuteSQL Task do?
It runs any Redshift SQL (DDL, DML, COPY, UNLOAD) from the SSIS Control Flow through the Amazon Redshift Connection Manager. The SQL can be typed directly or read from an SSIS variable, and results can be stored as a full result set (ADO.net DataTable in an Object variable) or a single value. It is 100% managed code, so it works in 32-bit and 64-bit.
Can the SQL be dynamic?
Yes. Set SqlStatementSourceType to Variable and put the variable name in SqlStatementSource; the task runs whatever SQL the variable holds at runtime.
Do I need an ODBC driver to connect to Redshift?
No. The task connects through the ZappySys Amazon Redshift Connection Manager (host, port, database, user name and password, with optional SSL), so no extra driver is needed.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
Start your free trial today
Install SSIS PowerPack and drag Amazon Redshift ExecuteSQL Task onto the Control Flow.
Send any SQL query to an Amazon Redshift cluster without needing an ODBC driver.
- Control Flow Task in SSISAmazon Redshift ExecuteSQL Task appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.