Package element: OLE DB Source

CollapseAll image

Collapse image 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

Collapse image 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

Collapse image See also


Package index