question

WilliamMoore-6708 avatar image
0 Votes"
WilliamMoore-6708 asked Yufeishao-msft commented

MDS: How to set String Value to NULL through stg tables?

I'm trying to set a string field in MDS to NULL using the staging tables. Per this documentation, https://docs.microsoft.com/en-us/sql/master-data-services/leaf-member-staging-table-master-data-services?view=sql-server-ver15, setting it to NULL will just have the field ignored when the ImportType is 0. So if you want to overwrite an existing value with NULL, you need to import the string as ~NULL~. But the field I'm working with is only NVARCHAR(3), which causes the stage table to truncate to ~NU. Is there any other way to do this?

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

if you can try to alter nvarchar length

0 Votes 0 ·

0 Answers