Package element: LKUP - Look up query plans on target server
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 |
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 |