I 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 output