Data truncation error in SSIS is the most common error if you are reading data from some flat file or Excel source. In this post we will look at how to fix truncation error while reading an Excel file. Excel source analyzes first 8 rows (row 2 to row 9) to set