Using the Amazon RedShift Source Component

The Amazon Redshift Source component is a SSIS data flow pipeline component that can be used to read / retrieve data from Amazon Redshift. The component includes the following three pages to configure how you want to read data.

  • General
  • Columns
  • Pre & Post Command

General

The General page of the Amazon Redshift Source component allows you to specify the general settings of the component.

Amazon Redshift Source - General Page

Connection Manager

The Amazon Redshift Source component requires a connection to connect to Amazon Redshift instance. The Connection Manager drop-down will show a list of all Amazon Redshift connection managers that are available in your current SSIS package.

Data Source

This field gives you a drop-down of all the available data sources based on the connection manager chosen.

Command Timeout

The Command Timeout option allows you to specify the number of seconds for the command timeout values. The default value is 120 seconds.

Transaction Type

This option allows you to specify the type of transactions by choosing Explicit and selecting an Isolation Level or by choosing Implicit.

Transaction Isolation Level (When Transaction Type is chosen as Explicit)

The Transaction Isolation Level option allows you to specify concurrency behaviors. The below options are available.

  • Chaos
  • Read Committed
  • Read Uncommitted
  • Repeatable Read
  • Serializable
  • Snapshot
Prepare Command

This option is enabled by default. Preparing commands protects against SQL injection. Only disable this option when it is required, and you have absolute control over the values being merged into the command

Command

The Command textbox is the command text that will be executed over the Connection Manager to read data from the Data Source. A basic select statement can easily be generated by selecting a table from the Data Source property. You can then further customize the command to your liking to perform powerful queries.

Command Preview

By clicking on Preview button, you can view up to top 200 rows of the result set for the command you have specified.

Amazon Redshift Source - Command Preview

Import

Loads command from a file into the Command property.

Export

Save the command in the Command property to a file.

Expression fx Button

Launches the SSIS Expression Editor to enable dynamic updates of the property at run time.

Generate Documentation Button

Generates a Word document which describes the component's metadata including relevant mapping, and so on.

Columns

The Columns page of the Amazon RedShift Source Component shows you the available columns based on the settings in the General page.

Amazon Redshift Source - Columns Page

On the top left of the grid, the checkbox can be used to toggle the selection of all the available fields. This is a productive way to check or uncheck all available fields.

Amanzon RedShift Field

This column lists the names of the fields available from the data source (or command).

Data Type

This column shows the datatype of the respective field.

Pre & Post Commands

The Pre & Post command page can be used to specify any command that needs to be run before and after the component has been executed.

Amazon Redshift Source component - Pre and Post Commands

Pre-Command

The Pre-Command will be executed in Pre-Execute. Leave blank to NOT execute any command.

Post Command

The Post-Command will be executed in Post-Execute. Leave blank to NOT execute any command.