Package element: ODD - Upload interesting sql handles

CollapseAll image

Collapse image Properties


 Name   Value 
AreInputColumnsValid True
ComponentClassID {7B729B0A-4EA5-4A0D-871A-B6E7618E9CFB}
ContactInfo OLE DB Destination;Microsoft Corporation;Microsoft SqlServer 2015; (C) 2014 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4
Description OLE DB Destination
ID 437
IdentificationString ODD - Upload interesting sql handles
IsDefaultLocale True
LocaleID English (United States)
Name ODD - Upload interesting sql handles
ObjectType 10
PipelineVersion 0
UsesDispositions True
ValidateExternalMetadata True
Version 4

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
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
FastLoadKeepIdentity Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on. CustomPropertyCollection
FastLoadKeepNulls Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destinaton. Applies only if fast load is turned on. CustomPropertyCollection
FastLoadOptions Specifies options to be used with fast load. Applies only if fast load is turned on. CustomPropertyCollection
FastLoadMaxInsertCommitSize Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on. CustomPropertyCollection
OLE DB Destination Input   InputCollection
OLE DB Destination Error Output   OutputCollection
OleDbConnection The OLE DB runtime connection used to access the database. RuntimeConnectionCollection

Collapse image See also


Package index