Package element: SqlCommand
Properties
| Name | Value |
| ContainsID | False |
| Description | Specifies the SQL statement that generates the lookup table. |
| EncryptionRequired | False |
| ExpressionType | CPET_NOTIFY |
| ID | 16 |
| IdentificationString | LKU - Lookup into performance_counter_instances to obtain performance_counter_id for all counter paths that get inserted.Properties[SqlCommand] |
| Name | SqlCommand |
| ObjectType | OT_PROPERTY |
| State | PS_DEFAULT |
| TypeConverter | |
| UITypeEditor | Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 |
| Value | SELECT path, performance_counter_id FROM snapshots.performance_counter_instances |
See also