Variable - NewInsertDimRelativeDay

Property	Value
Name	NewInsertDimRelativeDay
Value	Expression: " /* SQL INSERT NEW Rows into DimRelativeDay from DWOperations Temp New Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimRelativeDay] ( RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,[RelativeDayFullDescription_Sort] ,[RelativeDayFullDescription] ) SELECT RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,0 ,'N/A' FROM dbo.Staged_dbo_DimRelativeDay__New " / SQL INSERT NEW Rows into DimRelativeDay from DWOperations Temp New Table */ INSERT INTO [EnterpriseDW].[dbo].[DimRelativeDay] ( RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,[RelativeDayFullDescription_Sort] ,[RelativeDayFullDescription] ) SELECT RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,0 ,'N/A' FROM dbo.Staged_dbo_DimRelativeDay__New
Value Type	String
Description	This variable contains the SQL statement that will be used to insert new rows into the DimTerm table.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimRelativeDay
Evaluate As Expression	True
Expression	" /* SQL INSERT NEW Rows into DimRelativeDay from DWOperations Temp New Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimRelativeDay] ( RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,[RelativeDayFullDescription_Sort] ,[RelativeDayFullDescription] ) SELECT RelativeDaySK , Term , TermYear , TermTypeCode , TermTitle , RelativeDayNumber , RelativeDay , RelativeDayDate , RelativeDayDateSK , RowIsCurrent , RowStartDate , RowEndDate ,0 ,'N/A' FROM dbo.Staged_dbo_DimRelativeDay__New "
ID	e36b798b-21f7-437b-a5e9-cda101e8962e
Raise Changed Event	False