Package element: OLE DB Source
Properties
| Name | Value |
| AreInputColumnsValid | True |
| ComponentClassID | {D1AA3237-CE07-40F9-AA7D-DB75A2552BAC} |
| ContactInfo | OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7 |
| Description | OLE DB Source |
| ID | 39 |
| IdentificationString | OLE DB Source |
| IsDefaultLocale | True |
| LocaleID | English (United States) |
| Name | OLE DB Source |
| ObjectType | 9 |
| PipelineVersion | 0 |
| UsesDispositions | True |
| ValidateExternalMetadata | True |
| Version | 7 |
Elements
| Name | Description | Type |
| CommandTimeout | The number of seconds before a command times out. A value of 0 indicates an infinite time-out. | CustomPropertyCollection |
| OpenRowset | Specifies the name of the database object used to open a rowset. | CustomPropertyCollection |
| OpenRowsetVariable | Specifies the variable that contains the name of the database object used to open a rowset. | CustomPropertyCollection |
| SqlCommand | The SQL command to be executed. | CustomPropertyCollection |
| SqlCommandVariable | The variable that contains the SQL command to be executed. | CustomPropertyCollection |
| DefaultCodePage | Specifies the column code page to use when code page information is unavailable from the data source. | CustomPropertyCollection |
| AlwaysUseDefaultCodePage | Forces the use of the DefaultCodePage property value when describing character data. | CustomPropertyCollection |
| AccessMode | Specifies the mode used to access the database. | CustomPropertyCollection |
| ParameterMapping | The mappings between the parameters in the SQL command and variables. | CustomPropertyCollection |
| OLE DB Source Output | OutputCollection | |
| OLE DB Source Error Output | OutputCollection | |
| OleDbConnection | The OLE DB runtime connection used to access the database. | RuntimeConnectionCollection |
See also