Included in SSIS PowerPack

SSIS Amazon Redshift Source

Read data from Amazon Redshift.

SSIS Amazon Redshift Source can be used to read data from Amazon Redshift. You can use simple Table mode or write custom SQL Query to extract desired data.

The trial includes Amazon Redshift Source and every other PowerPack component

Amazon Redshift Source in SSDT
Amazon Redshift Source - Create new connection
Read data from Amazon RedshiftExplore 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 Source can do

SSIS Amazon Redshift Source can be used to read data from Amazon Redshift. You can use simple Table mode or write custom SQL Query to extract desired data.

Read Redshift in Data Flow

Read data from Amazon Redshift inside the SSIS Data Flow, without S3 staging.

  • Send the rows to any SSIS destination or transformation
  • Use the Amazon Redshift Destination when you also need to write back

Read / write Redshift guide

Table or Query mode

Use simple Table mode or write a custom SQL query to extract the data you need.

  • AccessMode: Table or Query
  • Pick the table from the Tables dropdown

See the modes

Dynamic queries

Insert SSIS variables anywhere in the query with placeholders.

  • e.g. select * from mytable where id='{{User::MyVar}}'
  • Variables can supply column names as well as values

Component help

Preview & max rows

Preview data at design time and limit how many rows are fetched.

  • MaxRows: 0 = unlimited

Component properties

Secure Redshift connection

Connect with host, database, user name and password through the Amazon Redshift Connection Manager.

  • Enable SSL
  • X509 client certificate from a certificate store or file

Connection Manager help

Connection performance

Tune how the connection behaves while the package runs.

  • Connection pooling for better performance
  • RetainSameConnection keeps one connection open for the whole package
  • Separate command and connect timeouts

Connection Manager help

Logging control

Control how much information is logged during package execution.

  • LoggingMode: Normal, Medium, Detailed or Debugging
  • PrefixTimestamp adds a timestamp to log messages

Component properties

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
  • Read data from Amazon Redshift in the SSIS Data Flow without S3 staging
  • Multiple modes (Table or Query) to read data from Amazon Redshift
  • Data preview and max rows
  • Dynamic query using SSIS variable placeholders (e.g. {{User::MyVar}})
  • SSL and X509 client certificate support on the Amazon Redshift Connection Manager
  • Connection pooling and RetainSameConnection to share one open connection across tasks
  • Command and connect timeout settings
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix
  • 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 Source page and help file, with the screens you will see in SSDT.

Connect to your Redshift cluster.

Drag Amazon Redshift Source onto the Data Flow and create an Amazon Redshift connection: enter the host name, user name, password and database, check Enable SSL if needed, and click Test Connection.

Amazon Redshift Source - Create new connection

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Amazon Redshift Source product page. Step through them, or open any shot at full size.

Amazon Redshift Source – Create new connection

Create the Amazon Redshift connection with host, database, user name and password.

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 Source on the canvas.

What is Amazon Redshift Source?

SSIS Amazon Redshift Source can be used to read data from Amazon Redshift. You can use simple Table mode or write custom SQL Query to extract desired data.

Do I need S3 staging to read Redshift data?

No. The source reads Redshift data directly in the SSIS Data Flow, without S3 staging. See How to Read / Write Amazon Redshift Data in SSIS.

How do I pass SSIS variables into the query?

Set AccessMode to Query and use placeholders such as {{User::MyVar}} anywhere in the SQL, for example select * from mytable where id='{{User::MyVar}}'. A variable can supply a column name as well as a value.

Can I connect over SSL?

Yes. The Amazon Redshift Connection Manager has an Enable SSL option and can use an X509 client certificate from a certificate store or file. See the connection manager help.

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 Source onto the Data Flow.

Read data from Amazon Redshift.

  • Data Flow Source in SSISAmazon Redshift Source 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 / 7