| Name |
SSISConfigurations_UPDATE_DWStaging |
| Value |
 Expression: "UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = '" + @[User::DWStagingSnapShotName] + "'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\\Package.Connections[DWStaging].Properties[InitialCatalog]'
"
UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = 'DWStaging_ETL_20170309_172829'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\Package.Connections[DWStaging].Properties[InitialCatalog]'
|
| Value Type |
String |
| Description |
This variable contains the SQL statement that will update the DWStagingDBName variabl ewith that of the Staging Snapshot so that it can be used in the rest of the packages that will be executed. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SSISConfigurations_UPDATE_DWStaging |
| Evaluate As Expression |
True |
| Expression |
"UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = '" + @[User::DWStagingSnapShotName] + "'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\\Package.Connections[DWStaging].Properties[InitialCatalog]'
" |
| ID |
c7a9eae1-eab8-441f-8844-67650fe87a50 |
| Raise Changed Event |
False |
Properties
