Content

• Video Tutorial
• Step-By-Step
• Properties
• Setting UI
• See Also
• References

Video Tutorial

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.
   
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.
   
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.
   
2. Now, click on New Button for create Connection.
   
3. Let's Configure Connection Manager, just Follow steps one by one as we have created.
   
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.
   
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.
   
    
5. Click on [Component Properties] and Pick the destination Table from Tables dropdown list.
   
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.
   
7. Execute the package and verify that the data is saved.
   

Properties

Setting UI

See Also

• SSIS Amazon Redshift Data Transfer Task
• SSIS Amazon Redshift Connection Manager
• SSIS Amazon Storage Task
• SSIS Amazon DynamoDB Source
• SSIS Amazon DynamoDB Destination