| 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_172829 |
| Value Type |
String |
| Description |
This variable will contain the name of the Snaphot that is created. It is a concatenation of the DWStagingDBName and the date and time of the package execution. |
| 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 |
e752c1ca-641b-4aeb-bcf1-3bc951cd2181 |
| Raise Changed Event |
False |
Properties
