SSIS Amazon Redshift Destination

SSIS Amazon Redshift Destination  can be used to bulk insert large amount of records to Amazon Redshift storage from any data source using SSIS. Amazon Redshift is a cloud based Data Warehouse service from Amazon AWS.

Download SSIS PowerPack


Video Tutorial

Coming soon...


In this section you will learn how to use Amazon Redshift Destination.In this case its from SQL Table Server.
  1. For this sample exercise we will create a table in RedShift.
    CREATE TABLE public."tbl_pg_Customers"
        "RecordID" character varying(50) NOT NULL,
        "CustomerID" character varying(50),
        "CustomerName" character varying(50),
        "Address1" character varying(50),
        "City" character varying(50),
        "State" character varying(50),
        "Zip" character varying(50),
        "Country" character varying(50),
        PRIMARY KEY ("RecordID")
  2. Once you have created the table, you may proceed to create new SSIS package. In BIDS/SSDT create new SSIS package.
  3. You need to Download and Install SSIS ZappySys PowerPack.
  4. After you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  5. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
    SSIS Data Flow Task - Drag and Drop
  6. Double click on the Data Flow task to see Data Flow designer surface.
  7. Here, In Visual Studio, drag and drop the OLE DB Source and Amazon Redshift Destination in the design surface and join the components with the blue arrow.
    SSIS Amazon Redshift Destination - Drag and Drop
  8. Now, we need OLE DB Connection and Amazon Redshift Connection. Click here for create Amazon Redshift Connection.

How to Create OLE DB Connection.

  1. Let's, Right click on Connection Managers Panel to Create OLEDB Connection, so you can use Source and Context Menu will appear, Select New OLEDB Connection from the Context Menu.
    SSIS OLEDB - Connection
  2. Now, click on New Button for create Connection.
    SSIS OLEDB - Connection
  3. Let's Configure Connection Manager, just Follow steps one by one as we have created.
    SSIS OLEDB - Connection
  4. Click on OK button to save configure setting UI.

How to write data into Amazon Redshift using Amazon Redshift Destination.

  1. Double click on OLE DB Source for configure it.
  2. Lets Configure in Connection Manager, just follow below image steps.
    SSIS OLEDB Connection Configure
  3. Click OK to Save OLEDB Source Editor UI Settings.
  4. Now double click on Amazon Redshift Destination to configure it. On [Connection Manager] tab select Amazon Redshift Connection manager.
    SSIS Amazon Redshift Destination - Select Connection
  5. Click on [Component Properties] and Pick the destination Table from Tables dropdown list.
    SSIS Amazon Redshift Destination - Component Properties
  6. Click on [Mappings] tab and verify mapping. If target table is new table and its empty then all input columns will be automatically mapped as shown below. If table is existing table with some data then you can manually pick mapping columns by dragging it from source list to target list.
    SSIS Amazon Redshift Destination - Columns Mapping Tab
  7. Execute the package and verify that the data is saved.
    SSIS Amazon Redshift Destination - Execute Package


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

Available Options

Option Description
Normal Normal is the lowest level of detail logged
Medium Medium provides more information than normal, but less than detailed
Detailed Detailed provides more detail than the medium option, but less than debugging
Debugging Debugging is the maximum level of detail logged
PrefixTimestamp When you enable this property it will prefix timestamp before Log messages.
LocalID Specifies the locale that the component uses to interpret locale-sensitive data such as data and time data.
TableName The table name where you read data. This option only used when AccessMode=Table
BatchSize How many rows you want to process in each request.

Setting UI

SSIS Amazon Redshift Destination - Setting UI
SSIS Amazon Redshift Destination - Setting UI

See Also

Articles / Tutorials

Click here to see all articles for [SSIS Amazon Redshift Source] category
How to Read / Write Amazon Redshift Data in SSIS

How to Read / Write Amazon Redshift Data in SSIS

Introduction ZappySys provide high-performance drag and drop connectors for Amazon Redshift Integration. In our previous post we saw how to bulk load SQL data into Redshift using S3 staging technique (COPY command). Now in this post, you will see How to Read / Write Amazon Redshift Data in SSIS Data flow without need for S3 Staging. […]

Copyrights reserved. ZappySys LLC.