EDWDifferentialBackup
 CurrentDateTimeStamp (Variable)
  Properties
Property Value
Name CurrentDateTimeStamp
Value Expression: (DT_WSTR,4)YEAR( GETDATE() ) + RIGHT("0" + (DT_WSTR,2)MONTH( GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE() ), 2) + "_" + RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DATEPART("mi", GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DATEPART("ss", GETDATE() ), 2)

20170309_174532
Value Type String
Description
System Variable False
Namespace User
Qualified Name User::CurrentDateTimeStamp
Evaluate As Expression True
Expression (DT_WSTR,4)YEAR( GETDATE() ) + RIGHT("0" + (DT_WSTR,2)MONTH( GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE() ), 2) + "_" + RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DATEPART("mi", GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DATEPART("ss", GETDATE() ), 2)
ID e5c65682-763f-4543-ab38-79d1827ee365
Raise Changed Event False
Powered by BI Documenter