Variable - NewInsertDimPurchaseOrder

Property	Value
Name	NewInsertDimPurchaseOrder
Value	Expression: " /* SQL INSERT into DimPurchaseOrderfrom New Temp Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] (PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate FROM dbo.Staged_dbo_DimPurchaseOrder__New " / SQL INSERT into DimPurchaseOrderfrom New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimPurchaseOrder] (PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate FROM dbo.Staged_dbo_DimPurchaseOrder__New
Value Type	String
Description	This variable contains the string that will be used to insert any new rows into the DimPurchaseOrder table.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimPurchaseOrder
Evaluate As Expression	True
Expression	" /* SQL INSERT into DimPurchaseOrderfrom New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimPurchaseOrder] (PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT PurchaseOrderAK ,FiscalYear ,PurchaseOrderNumber ,PoStatusCode ,PoStatus ,ReceivingStatusCode ,ReceivingStatus ,PayStatusCode ,PayStatus ,PoTypeCode ,PoType ,BuyerId ,Buyer ,RowIsCurrent ,RowStartDate ,RowEndDate FROM dbo.Staged_dbo_DimPurchaseOrder__New "
ID	926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event	False