Package element: SourceSqlQuery
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] |