ODBC Source Custom Properties

 

Applies To: SQL Server 2016

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

Property nameData TypeDescription
ConnectionODBC ConnectionAn ODBC connection to access the source database.
AccessModeInteger (enumeration)The mode used to access the database. The possible values are Table Name (0) and SQL Command (1).

The default is Table Name (0).
BatchSizeIntegerThe size of the batch for bulk extraction. This is the number of records extracted as an array. If the selected ODBC provider does not support arrays, the batch size is 1.
BindCharColumnAsInteger (enumeration)This property determines how the ODBC source 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).

 Note: This property is not available in the ODBC Source Editor, but can be set by using the Advanced Editor.
BindNumericAsInteger (enumeration)This property determines how the ODBC source binds columns with numeric data with data types SQL_TYPE_NUMERIC and SQL_TYPE_DECIMAL.

The possible options 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 Source Editor, but can be set by using the Advanced Editor.
DefaultCodePageIntegerThe code page to use for string output columns.

 Note: This property is not available in the ODBC Source Editor, but can be set by using the Advanced Editor.
ExposeCharColumnsAsUnicodeBooleanThis property determines how the component exposes CHAR columns. The default value is False, which indicates that CHAR columns are exposed as multi-byte strings (DT_STR). If True, CHAR columns are exposed as wide strings (DT_WSTR).

 Note: This property is not available in the ODBC Source Editor, but can be set by using the Advanced Editor.
FetchMethodInteger (enumeration)The method used for getting the data. The possible options are Row by row (0) and Batch (1). The default value is Batch (1).

For more information about these options, see ODBC Source.

 Note: This property is not available in the ODBC Source Editor, but can be set by using the Advanced Editor.
SqlCommandStringThe SQL command to be executed when AccessMode is set to SQL Command.
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. A value of 0 indicates that the system does not time out.
TableNameStringThe name of the table with the data that is being used when AccessMode is set to Table Name.
LobChunckSizeIntegerThe chunk size allocation for LOB columns.

ODBC Source
ODBC Source Editor (Connection Manager Page)

Community Additions

ADD
Show: