Package element: SourceSqlQuery
Properties
| Name | Value |
| CreationName | |
| DataType | String |
| Description | |
| EvaluateAsExpression | True |
| Expression | "EXEC [snapshots].[sp_get_unknown_query_text] @source_id = " + (DT_WSTR,50) @[User::SourceId] |
| IncludeInDebugDump | False |
| Name | SourceSqlQuery |
| Namespace | User |
| QualifiedName | User::SourceSqlQuery |
| RaiseChangedEvent | False |
| ReadOnly | False |
| SystemVariable | False |
| Value | EXEC [snapshots].[sp_get_unknown_query_text] @source_id = 1 |
| VariablePath | \Package\SEQ - Capture and analyze query statistics and query plan and text\DFT - Find and save sql text.Variables[User::SourceSqlQuery] |
See also