The problem is that the maximum length DT_NTEXTis a 2^30 ~ 1.073billion characters, and DT_WSTRmax is 4000 characters.
If all of your fields are less than 4000, try Data Transformation Conversion , and this may cause a warning at design time. You should add this sooner than after Converting derived columns .