| Name |
SSISConfigurations_UPDATE_DWStaging |
| Value |
 Expression: "UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = '" + @[User::DWStagingDBName] + "'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\\Package.Connections[DWStaging].Properties[InitialCatalog]'
"
UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = 'DWStaging'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\Package.Connections[DWStaging].Properties[InitialCatalog]'
|
| Value Type |
String |
| Description |
This is the SQL statement to update the SSIS_Configuration setting for the DWStaging Connecttion Manager. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SSISConfigurations_UPDATE_DWStaging |
| Evaluate As Expression |
True |
| Expression |
"UPDATE [dbo].[SSIS Configurations]
SET ConfiguredValue = '" + @[User::DWStagingDBName] + "'
WHERE ConfigurationFilter = 'ConnMgr_DWStaging'
AND PackagePath = '\\Package.Connections[DWStaging].Properties[InitialCatalog]'
" |
| ID |
c7a9eae1-eab8-441f-8844-67650fe87a50 |
| Raise Changed Event |
False |
Properties
