InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:44:27 GMT20http://www.sqlservercentral.com/Forums/Topic1406234-364-1.aspxIn the OLE DB Destination, you won't get Truncation Errors (those are used in the pipeline of the dataflow). If there's a truncation error, it happens in the database engine and SSIS regards it as any other error. So you need to configure On Error.Tue, 15 Jan 2013 02:21:50 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1406234-364-1.aspxI have an ssis Job (SSIS 2008) that loads data from a flat file to an SQL server 2008 table.I have a dataflow component where I do some transformations, and load to the database using an OLE DB Desination.on the destination, I configured the data access mode to: "table or view"however, when I open the error output, I can not configure an error on truncation. The field is grayed out.What am I missing, why can't I configure the error outputFri, 11 Jan 2013 12:41:03 GMTsandra pastrana