Export (0) Print
Expand All
Expand Minimize

ADO NET Custom Properties

Source Custom Properties

The ADO NET source has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the ADO NET source. All properties are read/write.

Property name

Data Type

Description

CommandTimeout

String

A value that specifies the number of seconds before the SQL command times out. A value of 0 indicates that the command never times out.

SqlCommand

String

The SQL statement that the ADO NET source uses to extract data.

When the package loads, you can dynamically update this property with the SQL statement that the ADO NET source will use. For more information, see Integration Services (SSIS) Expressions and Use Property Expressions in Packages.

AllowImplicitStringConversion

Boolean

A value that indicates whether the following occurs:

  • No generation of a validation error if there is a mismatch between external metadata types and output column types that are strings (DT_WSTR or DT_NTEXT).

  • Implicit conversion of external metadata types to the string data type that the output column uses.

The default value is TRUE.

For more information, see ADO NET Source.

The output and the output columns of the ADO NET source have no custom properties.

For more information, see ADO NET Source.

Destination Custom Properties

The ADO.NET destination has both custom properties and the properties common to all data flow components.

The following table describes the custom properties of the ADO.NET destination. All properties are read/write. These properties are not available in the ADO NET Destination Editor, but can be set by using the Advanced Editor.

Property

Data Type

Description

BatchSize

Integer

The number of rows in a batch that is sent to the server. A value of 0 indicates that the batch size matches the internal buffer size. The default value of this property is 0.

CommandTimeOut

Integer

The maximum number of seconds that the SQL command can run before timing out. A value of 0 indicates an infinite time. The default value of this property is 0.

TableOrViewName

String

The name of the destination table or view.

For more information, see ADO NET Destination.

Community Additions

ADD
Show:
© 2014 Microsoft