Issue importing large file into SQL server
You're getting a truncation error, meaning the data that's coming in is larger than the field size you have specified.  Try increasing the destination table field size and you should be good to go.

I get these alot when I work with email addresses as the SQL import wizard defaults to 50, I always have to increase it every time I do a fresh import.