Trying to use SQLBulkCopy to upload a data table into SQL.
I'm getting this error:
String or binary data would be truncated.
The SQL column is defined as nvarchar(50)
I changed the column to nvarchar(150) and same problem
One of the actual lines that's blowing it is: Enter the Location of Inspection
This character length is 32 with spaces
If I remove "on" then it works and imports.
So what's the deal with a column defined as 50 nvarchar and 32 characters going into it.?