I am uploading a 3.2 million row file with two columns. I first create the table I want the data to go into and set the columns to be NVARCHAR(Max) and then start the import.
The system reads all rows and from the log shows that all rows were loaded correctly. I do not get errors during upload and the system does not kick any rows out.
However when I look at the Table on the system is has ~700K rows only versus the full 3.2M rows?
I am new to this so maybe i am missing something obvious but if someone can help that would be great.