[Flat File Source ] Error: The "output column "Column [ ]" failed because truncation occurred, and the truncation row disposition on "output column " Column [ ]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. – How to resolve this error from SSIS (Integration Service)?
Most likely you are experiencing this while you are trying to import or export data from/to flat file using SSIS and using Falt file connection. This is coming because the flat file defaults initially all columns to characters with width of 50 and your flat file’s column width is more than 50. To resolve this, you need to go to Advance page of the Flat File connection manager page and change the “column width” manually.
You can use Suggest Type Button also in Advance Page where SQL Server will suggest the configuration details of flat file connection based on available input. Personally I recommend to review the suggestion and then change the configuration manually only after reviewing the actual flat file I am using.
Snapshot of Advance Page of a Flat File Connection Manager:
To learn more about Flat File Connection Manager, please refer to http://msdn.microsoft.com/en-us/library/ms140266.aspx