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