Teradata Destination

Overview

The Teradata Destination Component is an SSIS Data Flow Component which connects to a Teradata database and bulk loads data into Teradata database tables. It is up to 80x faster than the standard loading using ODBC Destination. The configuration parameters are provided in the standard data flow destination component dialog. The component requires installation of Teradata Tools and Utilities 13.10. Install the following Teradata components:

Select the bulk-load driver. This parameter has the options listed in the following table.

Action

Description

Load

Use the Load driver. Use this option when the destination table is empty and there are no secondary indexes defined.

Update

Use the Update driver. Use this option when the destination table already contains data. The destination is locked during processing.

Stream

Use the Stream driver. Use this option when you want to avoid locking of the destination table during processing.

DestinationTable

Specify the destination database table where the data is to be loaded.

ErrorLimit

Specify the maximum number of errors allowed before the component stops processing. The default is 0.

DataEncryption

Indicates whether full security encryption of SQL requests, responses and data is to be used. This parameter has the options listed in the following table.

Value

Description

True

All SQL requests, responses, and data are encrypted.

False

No encryption occurs. This is the default setting.

ErrorTable

Specifies an error table. If not specified, a default error table will be set up with a name based on the selected destination table.

MinSessions

Specifies the minimum number of sessions to be used during processing. The default is 1.

MaxSessions

Specifies the maximum number of sessions to be used during processing. The default is 4.

TraceFile

Specifies the name of the external file to use for tracing messages.

TenacityHours

Specifies the number of hours that the driver continues trying to log on when the maximum number of load and export operations are already running on the Teradata Database. The default value is four hours.

TenacitySleep

Specifies the number of minutes that the driver pauses before retrying to log on when the maximum number of load and export operations are already running on the Teradata Database. The default is six minutes.

AppendErrorTable

Indicates whether or not the Stream Operator will use the existing error table.

Value

Description

True

Stream operator will use the existing error table or create the
error table if it does not exist.

False

Stream operator will not use the existing error table (default).

FAQ

How to modify destination table dynamically at runtime

The destination table is available in the data flow properties list. Follow these steps to set up an expression:

Right-click on the data flow canvas and select the Properties menu.

Scroll down and find the property named like [Teradata Destination].[DestinationTable]. This is the property containing the destination table.

Scroll down and find the Expressions property. Set up an expression to modify the table dynamically.