Workbook over writes with empty value good data

[Ghislain Hachey]

When loading a workbook some data gets written directly to tables (e.g. tPayroll to TeacherIdentity). Problem with this as it currently stands is it is always at risk of over writing good data with NULL. For example, if a workbook does not have all the social security numbers by accident and it is loaded. All the social security numbers are lost. I think it should be something more like this.

• Updating with data from workbook when there is some as default behavior: ok.
• If no data in workbook but there is data in tables: leave untouched.

‌

[Ghislain Hachey]

I am not sure how I managed to get into this described situation in a test environment. Looking at the code below from [pSurveyOps].[censusRolloverStaff] data in tables should never be over written by null.

, coalesce(tchProvident,
    nullif(ltrim(v.value('@OTHER_SSN', 'nvarchar(100)')),'')
    )   

‌