KoldCoffee (4/9/2014)
No Phil, that is not correct. You wrote to go to Advanced Editor of Flat File Source. But you didn't say to go to the Connection Manager for the Flat File Source. Very important distinction for anyone else who may read that.This was NOT solution:
....from flat file source to destination, using the Advanced Editor to view the data types that SSIS is using as the data passes through the pipeline.
This was solution:
from Flat File Connection Manager, Click Edit, and go to Advanced and evaluate that the size of the property 'OutputColumnWidth' accommodates the size of the input.
Flat File Source and Flat File Connection Manager are two different things:-)
OK, I see your point. It was not as precise as it could have been.
But notice how I used lower case for 'flat file source' and 'destination' - also very important, at least in my head (:-)), because without capitals they are not defined terms - just a generic source (which happens to be a flat file) and some destination.
My intention was for you to trace the entire data path, from beginning to end, which includes the definition of the file. My apologies.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.