Right.

What happens is that you have your two single quotes opening as text delimiter.

SSIS will continue reading data and adding it to the column until it encounters the two closing single quotes. It ignores everything that it comes accross - column delimiters, row delimiters and so on - until it encounters those other two single quotes.

Since your column mistakenly doesn't have those, SSIS goes on until the next row, where it finds two other single quotes. It thinks the column ends there. Result: your column is way too big because it included data from other columns.

Solution: choose a decent text delimiter or just don't use one at all but choose a decent column delimiter.

If neither is an option, you need to make sure that if a column opens with a text delimiter, it is also closed by a text delimiter.