Always doublecheck the string lengths - I'll confess to suffering this error when tring to insert values 8 characters long into a column that sp_help listed as Length = 12. The column was actually defined as nvarchar(6) ... oops!