Searched for the SQL Server error Truncation may occur due to inserting data from data flow column and found an article regarding on this titled Stripping out double quotes (") in bulk insert, what it does in the uploading is we set the text qualifier to a single quote and when we upload the text file is it removes all the single quote in the flat file before we upload the flat file with the single quote and is included in the character count. An example is if we have a season code of TAW when we upload the flat file the season code will be TA'. Now we remove the single quote and we successfully uploaded the TAW season code. I will monitor this in a couple of days. Set the new SSIS package in the SQL server using the text qualifier single quote.