visual studio 2012 - How do you represent NULL values in a bulk update file for SQL? -


i'm trying bulk update on table file bunch of \n values (i'm assuming these supposed null,) errors like

bulk load data conversion error (type mismatch or invalid character specified codepage) row 3, column 14 (cs).

it's assignment, , text file came data files provided through publishing company or whatever (which asp.net book.) i've been using visual studio sql functionality, rather sql server, , don't know if may causing problem... but...

is there way can represent null values in text file update table way it's supposed to? set fields nullable, , didn't work. tried find , replace on \n null , didn't work...


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -