| Name |
DWStagingSnapShotName |
| Value |
 Expression: @[User::DWStagingDBName]
+ "_ETL_" +
(DT_WSTR,8) (
(YEAR( @[System::ContainerStartTime] ) * 10000)
+
(MONTH( @[System::ContainerStartTime] ) * 100) +
DAY( @[System::ContainerStartTime] )
)
+ "_" +
RIGHT("0" + (DT_WSTR,2)DATEPART("hh", @[System::ContainerStartTime] ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("mi", @[System::ContainerStartTime] ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("ss", @[System::ContainerStartTime] ), 2)
DWStaging_ETL_20170309_174513 |
| Value Type |
String |
| Description |
This contains the name of the Snapshot that was created at the start of the control package. It is a concatenation of the name of the DWStaging database and the date and time of the start of the execution of the control package. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::DWStagingSnapShotName |
| Evaluate As Expression |
True |
| Expression |
@[User::DWStagingDBName]
+ "_ETL_" +
(DT_WSTR,8) (
(YEAR( @[System::ContainerStartTime] ) * 10000)
+
(MONTH( @[System::ContainerStartTime] ) * 100) +
DAY( @[System::ContainerStartTime] )
)
+ "_" +
RIGHT("0" + (DT_WSTR,2)DATEPART("hh", @[System::ContainerStartTime] ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("mi", @[System::ContainerStartTime] ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("ss", @[System::ContainerStartTime] ), 2)
|
| ID |
a34189ff-1331-40c3-afec-253f4239ecde |
| Raise Changed Event |
False |
Properties
