DimFeeTypeLoad
 NewInsertDimFeeType (Variable)
  Properties
Property Value
Name NewInsertDimFeeType
Value Expression: " /* SQL INSERT into DimFeeType from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimFeeType] (FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimFeeType__New "

/* SQL INSERT into DimFeeType from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimFeeType] (FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimFeeType__New
Value Type String
Description This variable contains the string that will be used to insert any new rows into the DimFeeType table.
System Variable False
Namespace User
Qualified Name User::NewInsertDimFeeType
Evaluate As Expression True
Expression " /* SQL INSERT into DimFeeType from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimFeeType] (FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT FeeTypeAK ,FeeTypeCode ,FeeType ,FeeCategoryCode ,FeeCategory ,FeeGroupCode ,FeeGroup ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimFeeType__New "
ID 926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event False
Powered by BI Documenter