Export (0) Print
Expand All

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 120. 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.

Community Additions

ADD
Show:
© 2014 Microsoft