Included in SSIS PowerPack

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

Amazon Redshift ExecuteSQL Task in SSDT
SSIS Amazon Redshift ExecuteSQL Task: Create new Amazon Redshift Connection in SSIS
Create the Amazon Redshift connection used by the taskExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

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

Execute SQL on Redshift guide

Any Redshift SQL command

Issue SQL commands such as CREATE, DROP, COPY and UNLOAD.

  • Example: drop a table if it exists, then create it

Execute SQL on Redshift guide

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 Variable
  • SqlStatementSource holds the SQL text or the variable name

Component help

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

Component help

Timeout & logging

Control command timeout and how much is logged.

  • Timeout in seconds (0 = no timeout)
  • LoggingMode: set Debugging for maximum log

Component help

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 Manager help

Connection performance

Tune how the connection behaves while the package runs.

  • Connection pooling
  • RetainSameConnection keeps one connection open for multiple tasks
  • Separate command and connect timeouts

Connection Manager help

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

Compatibility and requirements

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 RetainSameConnection to 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

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

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 new Amazon Redshift Connection in SSIS

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.

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.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

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.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 6