Variable - SCD1UpdateDimStudentReceipt

Property	Value
Name	SCD1UpdateDimStudentReceipt
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentReceipt] SET StudentReceiptAK = SCD1.StudentReceiptAK ,StudentId = SCD1.StudentId ,PrintedReceiptNumber = SCD1.PrintedReceiptNumber ,ReceiptCategory = SCD1.ReceiptCategory ,ReceiptProcesserCode = SCD1.ReceiptProcesserCode ,ReceiptProcesser = SCD1.ReceiptProcesser ,SessionDate = SCD1.SessionDate ,SessionSequenceNumber = SCD1.SessionSequenceNumber ,ReceiptSequenceNumber = SCD1.ReceiptSequenceNumber ,ReceiptTypeCode = SCD1.ReceiptTypeCode ,ReceiptType = SCD1.ReceiptType ,MiscellaneousReceiptCatecoryCode = SCD1.MiscellaneousReceiptCatecoryCode ,MiscellaneousReceiptCategory = SCD1.MiscellaneousReceiptCategory ,ReceiptReference = SCD1.ReceiptReference FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimStudentReceipt] SET StudentReceiptAK = SCD1.StudentReceiptAK ,StudentId = SCD1.StudentId ,PrintedReceiptNumber = SCD1.PrintedReceiptNumber ,ReceiptCategory = SCD1.ReceiptCategory ,ReceiptProcesserCode = SCD1.ReceiptProcesserCode ,ReceiptProcesser = SCD1.ReceiptProcesser ,SessionDate = SCD1.SessionDate ,SessionSequenceNumber = SCD1.SessionSequenceNumber ,ReceiptSequenceNumber = SCD1.ReceiptSequenceNumber ,ReceiptTypeCode = SCD1.ReceiptTypeCode ,ReceiptType = SCD1.ReceiptType ,MiscellaneousReceiptCatecoryCode = SCD1.MiscellaneousReceiptCatecoryCode ,MiscellaneousReceiptCategory = SCD1.MiscellaneousReceiptCategory ,ReceiptReference = SCD1.ReceiptReference FROM [EnterpriseDW].[dbo].[DimStudentReceipt] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimStudentReceipt__Type1Update] AS SCD1 ON Dim.StudentReceiptAK = SCD1.StudentReceiptAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimStudentTerm dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimStudentReceipt
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentReceipt] SET StudentReceiptAK = SCD1.StudentReceiptAK ,StudentId = SCD1.StudentId ,PrintedReceiptNumber = SCD1.PrintedReceiptNumber ,ReceiptCategory = SCD1.ReceiptCategory ,ReceiptProcesserCode = SCD1.ReceiptProcesserCode ,ReceiptProcesser = SCD1.ReceiptProcesser ,SessionDate = SCD1.SessionDate ,SessionSequenceNumber = SCD1.SessionSequenceNumber ,ReceiptSequenceNumber = SCD1.ReceiptSequenceNumber ,ReceiptTypeCode = SCD1.ReceiptTypeCode ,ReceiptType = SCD1.ReceiptType ,MiscellaneousReceiptCatecoryCode = SCD1.MiscellaneousReceiptCatecoryCode ,MiscellaneousReceiptCategory = SCD1.MiscellaneousReceiptCategory ,ReceiptReference = SCD1.ReceiptReference FROM " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False