SSIS Error: Data conversion failed. The data conversion for column “”RECIPIENT”” returned status value 4 and status text “Text was truncated or one or more characters had no match in the target code page.
- Right Click on Flat File Source and choose “Show Advanced Editor”
- Go to “Input and Output Properties “ Tab
- Expand “Flat File Source Output” and choose “External Columns”
- Select column that is causing this error (In my case column is “RECIPIENT” as per above error message) and on right hand side, increase length say 100 or 200 or depending on your column length
- Now select “Output Columns” and select same column as above and make this value same as we did in Step 4, in my case its 200 as shown below.
- Now run your package
Note: In my case column that’s caused this error is “RECIPIENT”