I have a package which imports data from csv file (tab delimited) to sql server database. earlier when testing with development DB there was no issues, but implementing the same to the testing DB it throwing multiple errors like truncation happened on "some column" but the staging table width was set to 4000, actual data length can not be more than 100.
I found what type of data is causing issue. I have given the sample screen shot with the attachment.
kindly have a look and let me know how to over come this issue.