Package element: LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted
Name | Value |
AreInputColumnsValid | True |
ComponentClassID | {EDED6488-9C19-496D-9F1D-99E1DB55AF77} |
ContactInfo | Lookup;Microsoft Corporation;Microsoft SqlServer 2015; (C) 2014 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4 |
Description | Looks up values in a reference dataset by using exact matching. |
ID | 15 |
IdentificationString | LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted |
IsDefaultLocale | True |
LocaleID | English (United States) |
Name | LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted |
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 |
CacheType | Specifies the cache type of the lookup table. | 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 |
ConnectionType | Specifies the type of connection used to access the reference dataset. | 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 |
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 |