Variable - NewInsertDimTerm

Property	Value
Name	NewInsertDimTerm
Value	Expression: " /* SQL INSERT into DimTerm on Operations from New Temp Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTerm] (TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate ) SELECT TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate FROM dbo.Staged_dbo_DimTerm__New " / SQL INSERT into DimTerm on Operations from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimTerm] (TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate ) SELECT TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate FROM dbo.Staged_dbo_DimTerm__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::NewInsertDimTerm
Evaluate As Expression	True
Expression	" /* SQL INSERT into DimTerm on Operations from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimTerm] (TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate ) SELECT TermSK , TermAK , TermStartDate , TermEndDate , TermTitle , AcademicYearCode , AcademicYear , TermYear , TermTypeCode , TermType , ActiveTerm , DefaultTerm , RelativeDay , PriorYearTerm , StateReportingTermYear , StateReportingTermSequence , RowIsCurrent , RowStartDate , RowEndDate FROM dbo.Staged_dbo_DimTerm__New "
ID	e36b798b-21f7-437b-a5e9-cda101e8962e
Raise Changed Event	False