SSIS Amazon Redshift Source Connector

SSIS Amazon Redshift Source Connector

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

Features

  • Multiple modes (i.e. Table or Query) to read data from Amazon Redshift Database
  • Support for data preview and max rows
  • Support for Dynamic query (using SSIS Variable placeholder e.g. select * from mytable where id=’{{User::MyVar}}’ )
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
  • Click here to see Amazon Redshift related articles
SSIS Amazon Redshift Source Connector - Video Tutorial
Download Help File Buy
View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements
SSIS Amazon Redshift Source - Create new connection


SSIS Amazon Redshift Source – Create new connection

SSIS Amazon Redshift Source - Read data in Table mode


SSIS Amazon Redshift Source – Read data in Table mode

SSIS Amazon Redshift Source - Read data in Query mode using FetchXML


SSIS Amazon Redshift Destination – Read data in SQL Query mode

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1, Windows 10
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This