Variable - NewInsertDimUser

Property	Value
Name	NewInsertDimUser
Value	Expression: " /* SQL INSERT into DimUser from New Temp Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimUser] ([DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT [DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate] FROM [dbo].[Staged_dbo_DimUser__New] " / SQL INSERT into DimUser from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimUser] ([DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT [DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate] FROM [dbo].[Staged_dbo_DimUser__New]
Value Type	String
Description	This variable contains the string that will be used to insert any new rows into the DimOrgUnit table.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimUser
Evaluate As Expression	True
Expression	" /* SQL INSERT into DimUser from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimUser] ([DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT [DomainUserId] ,[ApplicationUserId] , UserName ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate] FROM [dbo].[Staged_dbo_DimUser__New] "
ID	926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event	False