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 Receipt Rows from DimStudentReceipt for Old Students */ DELETE StRec FROM [EnterpriseDW].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN ( SELECT OldStudentIdAK FROM dbo.Obsolete_DimStudent as OldSt WHERE StRec.StudentId = OldSt.OldStudentIdAK )

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