in 'ETL_DimEmployee' this query :
SELECT
e.NationalIDNumber as EmployeeNationalIDAlternateKey
, manager.NationalIDNumber as ParentEmployeeNationalIDAlternateKey
, s.FirstName, s.LastName, s.MiddleName, e.JobTitle as Title
, e.HireDate, e.BirthDate, e.LoginID, s.EmailAddress
, s.PhoneNumber as Phone, e.MaritalStatus, e.SalariedFlag
, e.Gender, e.VacationHours, e.SickLeaveHours, e.CurrentFlag
, s.CountryRegionName as SalesTerritoryCountry
, s.TerritoryGroup as SalesTerritoryGroup
, s.TerritoryName as SalesTerritoryRegion
, s.StateProvinceName
FROM [Sales].[vSalesPerson] s
INNER JOIN [HumanResources].[Employee] e
ON e.[BusinessEntityID] = s.[BusinessEntityID]
LEFT OUTER JOIN HumanResources.Employee manager
ON (e.OrganizationNode.GetAncestor(1)) = manager.[OrganizationNode]

doesn't accommodate NOT NULL columns for NameStyle & SalesPersonFlag.
Otherwise OLEdb for 'Insert Destination' will fail.


btw, where I can get value from NameStyle & SalesPersonFlag ?