I was creating another SSIS project by copying to another project. The flat file source changed and the target SQL remained the same. I am getting this message"
[Flat File Source ] Error: Data conversion failed. The data conversion for column ""MyField"" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
and upon looking at the data I cannot see anything wrong. How do I put in an error trap that will give more detailed information?