| Name |
RetrieveListOfSnapshots |
| Value |
 Expression: "
SELECT d.name AS SnapshotName
FROM sys.databases d
WHERE d.source_database_id IS NOT NULL
AND d.name LIKE '" + @[User::DWStagingDBName] + "_ETL%'
"
SELECT d.name AS SnapshotName
FROM sys.databases d
WHERE d.source_database_id IS NOT NULL
AND d.name LIKE 'DWStaging_ETL%'
|
| Value Type |
String |
| Description |
This is the SQL statement that retrieve the list of snaphot names that have been created. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::RetrieveListOfSnapshots |
| Evaluate As Expression |
True |
| Expression |
"
SELECT d.name AS SnapshotName
FROM sys.databases d
WHERE d.source_database_id IS NOT NULL
AND d.name LIKE '" + @[User::DWStagingDBName] + "_ETL%'
" |
| ID |
03ba86c6-74ee-4f40-a4c5-9f907187d6b4 |
| Raise Changed Event |
False |
Properties
