Configuration setting from SSIS_Configuration to specify the domain where the e-mail server is running.

EnterpriseDW

Configuration setting in SSIS_Configurations that specifies the name of the Enterprise Data Warehouse.

N/A

If the Enterprise Data Warehouse resides on a different server from the DWStaging and DWoperations databases, a linked server must be defined and the name populated into the Var_EDWLinkedServername. If it resides on the same server, this setting must be set to ?N/A?. This is a configuration setting from SSIS_Configurations.

/* Remove Student Term Rows from DimStudentTerm for Old Students */ DELETE StTerm FROM [EnterpriseDW].[dbo].[DimStudentTerm] as StTerm WHERE StudentId IN ( SELECT OldStudentIdAK FROM dbo.Obsolete_DimStudent as OldSt WHERE StTerm.StudentId = OldSt.OldStudentIdAK )

" /* Remove Student Term Rows from DimStudentTerm for Old Students */ DELETE StTerm FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentTerm] as StTerm WHERE StudentId IN ( SELECT OldStudentIdAK FROM dbo.Obsolete_DimStudent as OldSt WHERE StTerm.StudentId = OldSt.OldStudentIdAK ) "