Share via


ODBC Source Custom Properties

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

Property name Data Type Description
Connection ODBC Connection An ODBC connection to access the source database.
AccessMode Integer (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).
BatchSize Integer The 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.
BindCharColumnAs Integer (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.
BindNumericAs Integer (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.
DefaultCodePage Integer The 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.
ExposeCharColumnsAsUnicode Boolean This 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.
FetchMethod Integer (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.
SqlCommand String The SQL command to be executed when AccessMode is set to SQL Command.
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 0. A value of 0 indicates that the system does not time out.
TableName String The name of the table with the data that is being used when AccessMode is set to Table Name.
LobChunckSize Integer The chunk size allocation for LOB columns.

See Also

ODBC Source
ODBC Source Editor (Connection Manager Page)