ODBC Destination Custom Properties

 

Applies To: SQL Server 2016

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

Property nameData TypeDescription
ConnectionODBC ConnectionAn ODBC connection to access the destination database.
BatchSizeIntegerThe 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.
BindCharColumnAsInteger (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.
BindNumericAsInteger (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.
DefaultCodePageIntegerThe 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.
InsertMethodInteger (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.
StatementTimeoutIntegerThe number of seconds to wait for an SQL statement to execute before returning, with an error, to the application. The default value is 120.
TableNameStringThe name of the destination table where the data that is being inserted.
TransactionSizeIntegerThe 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.
LobChunkSizeIntegerThe chunk size allocation for LOB columns.

Community Additions

ADD
Show: