bulk - BCP import result with null value invalid

Question

i have a text file (pipeline separator) with null value in some column. when i imported it to sql server with bcp utility, import was successful. however, i check the table with select query in SQL Server Management Studio and the result for null value invalid. invalid is column must be null value, it fill blank value. colomn must be blank value, it fill with null value. i was frusted. all the way i try, it never solved.

text file like this

command prompt for bcp like this

Result in SSMS like this

thank you all

question from:https://stackoverflow.com/questions/66064060/bcp-import-result-with-null-value-invalid

Answer 1

Waitting for answers