Export (0) Print
Expand All

ODBC Destination Custom Properties

The following table describes the custom properties of the ODBC destination. All properties can be set from SSIS property expressions.

Property name

Data Type

Description

Connection

ODBC Connection

An ODBC connection to access the destination database.

BatchSize

Integer

The size of the batch for bulk loading. This is the number of rows loaded as a batch. This is valid only if the row-wise parameter binding is supported. If the row-wise parameter binding is not supported, the batch size is 1.

BindCharColumnAs

Integer (enumeration)

This property determines how the ODBC destination binds columns with multiple-byte string types such as SQL_CHAR, SQL_VARCHAR, or SQL_LONGVARCHAR.

The possible values are Unicode (0), which binds the columns as SQL_C_WCHAR, and ANSI (1), which binds the columns as SQL_C_CHAR). The default is Unicode (0).

Unicode is the best option for most ODBC 3.x providers and ODBC 2.x providers that support binding CHAR parameters as wide strings. When you select Unicode and ExposeCharColumnsAsUnicode is True, the user does not need to specify the code page used by the source database.

Note: This property is not available in the ODBC Destination Editor, but can be set by using the Advanced Editor.

BindNumericAs

Integer (enumeration)

This property determines how the ODBC destination binds columns with numeric data with data types SQL_TYPE_NUMERIC and SQL_TYPE_DECIMAL.

The possible values are Char (0), which binds the columns as SQL_C_CHAR and Numeric (1), which binds the columns as SQL_C_NUMERIC. The default value is Char (0).

Note: This property is not available in the ODBC Destination Editor, but can be set by using the Advanced Editor.

DefaultCodePage

Integer

The code page to use for string columns.

Note: This property is not available in the ODBC Destination Editor, but can be set by using the Advanced Editor.

InsertMethod

Integer (enumeration)

The method used for inserting the data. The possible values are Row by row (0) and Batch (1). The default value is Batch (1).

For more information about these options, see “Load Options” in ODBC Destination.

StatementTimeout

Integer

The number of seconds to wait for an SQL statement to execute before returning, with an error, to the application. The default value is 120.

TableName

String

The name of the destination table where the data that is being inserted.

TransactionSize

Integer

The number of inserts in a single transaction. The default value is 0, which means that the ODBC destination works in auto commit mode.

Because the ODBC connection manager does not support distributed transactions, it is possible to set this property with a value other than 0. However, if the connection manager RetainSameConnection property is set to true then this property must be set to 0.

Note: This property is not available in the ODBC Destination Editor, but can be set by using the Advanced Editor.

LobChunkSize

Integer

The chunk size allocation for LOB columns.

Community Additions

ADD
Show:
© 2014 Microsoft