DimChartOfAccountLoad
 NewInsertDimChartOfAccount (Variable)
Home  Diagrams  Documents  Images  DimChartOfAccountLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimChartOfAccountLoad   Variables   NewInsertDimChartOfAccount
  Properties
Property Value
Name NewInsertDimChartOfAccount
Value Expression: " /* SQL INSERT into DimChartOfAccount from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimChartOfAccount] (YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [dbo].[Staged_dbo_DimChartOfAccount__New] "

/* SQL INSERT into DimChartOfAccount from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimChartOfAccount] (YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [dbo].[Staged_dbo_DimChartOfAccount__New]
Value Type String
Description This variable contains the string that will be used to insert any new rows into the DimStudentTerm table.
System Variable False
Namespace User
Qualified Name User::NewInsertDimChartOfAccount
Evaluate As Expression True
Expression " /* SQL INSERT into DimChartOfAccount from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimChartOfAccount] (YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT YearGlAccountNumberAK ,GlAccountNumber ,FiscalYear ,AccountStatusCode ,AccountStatus ,StartDate ,EndDate ,IsAccountBudgeted ,BudgetPoolNo ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [dbo].[Staged_dbo_DimChartOfAccount__New] "
ID 926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event False
Powered by BI Documenter