Package element: LKUP - Look up query plans on target server

CollapseAll image

Collapse image Properties


 Name   Value 
AreInputColumnsValid True
ComponentClassID {EDED6488-9C19-496D-9F1D-99E1DB55AF77}
ContactInfo Lookup;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5
Description Looks up values in a reference dataset by using exact matching.
ID 2
IdentificationString LKUP - Look up query plans on target server
IsDefaultLocale True
LocaleID English (United States)
Name LKUP - Look up query plans on target server
ObjectType 12
PipelineVersion 0
UsesDispositions True
ValidateExternalMetadata True
Version 6

Collapse image Elements


 Name   Description   Type 
SqlCommand Specifies the SQL statement that generates the lookup table. CustomPropertyCollection
SqlCommandParam Specifies a SQL statement that uses parameters to generate the lookup table. CustomPropertyCollection
ConnectionType Specifies the type of connection used to access the reference dataset. CustomPropertyCollection
CacheType Specifies the cache type of the lookup table. CustomPropertyCollection
NoMatchBehavior Specifies how the Lookup transformation handles rows without matching entries in the reference data set. CustomPropertyCollection
NoMatchCachePercentage Specifies the percentage of the cache that is allocated for rows with no matching entries in the reference dataset. CustomPropertyCollection
MaxMemoryUsage Maximum Memory Usage for Reference Cache on a 32 bit platform. CustomPropertyCollection
MaxMemoryUsage64 Maximum Memory Usage for Reference Cache on a 64 bit platform. CustomPropertyCollection
ReferenceMetadataXml Indicates whether to reference metadata in an XML format. CustomPropertyCollection
ParameterMap Specifies the list of lineage identifiers that map to the parameters that the SQL statement in the SQLCommand property uses. Entries in the list are separated by semicolons. CustomPropertyCollection
DefaultCodePage Specifies the column code page to use when code page information is unavailable from the data source. CustomPropertyCollection
TreatDuplicateKeysAsError Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used. CustomPropertyCollection
Lookup Input   InputCollection
Lookup Match Output   OutputCollection
Lookup No Match Output The Lookup output that handles rows with no matching entries in the reference dataset. Use this output when the NoMatchBehavior property is set to "Send rows with no matching entries to the no match output." OutputCollection
Lookup Error Output   OutputCollection
OleDbConnection Connection manager used to access lookup data. RuntimeConnectionCollection

Collapse image See also


Package index