in the advanced tab, the datatype is set to Unicode dt_stwr (something which is equivalent to nvarchar) and the width is 4000, actual data flows through the flat file is having a maximum of 22 only.

my question is, is there any transformation which could search for some condition and overcome these kind of issues in the future, as of now I have fixed it manualy (really tedious....)

is there any possible way to handle it in any of the transformation in sql2012.