TechNet
Export (0) Print
Expand All

ADO NET Custom Properties

 

Applies To: SQL Server 2016

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 nameData TypeDescription
CommandTimeoutStringA value that specifies the number of seconds before the SQL command times out. A value of 0 indicates that the command never times out.
SqlCommandStringThe 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.
AllowImplicitStringConversionBooleanA 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.

PropertyData TypeDescription
BatchSizeIntegerThe 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.
CommandTimeOutIntegerThe 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.
TableOrViewNameStringThe name of the destination table or view.

For more information, see ADO NET Destination.

Common Properties

Community Additions

ADD
Show:
© 2016 Microsoft