SQL Exception: A truncation error was encountered trying to shrink VARCHAR '...' to length x

It means your VARCHAR field (variable length string field) has a length of X, e.g. 100, while the data you were trying to insert was more than 100 characters long.

SQL Server will not automatically truncate your data at the maximum length of the varchar field - you have to make sure yourself not to insert more data than the field can hold.