title: SSIS Disable Truncation Warning
body: <p>I am importing from a flat file that all have a length of NVARCHAR(255).  The destination lengths vary but are usually smaller.  If truncation occurs when inserting into the destination I redirect the Row to an error output and continue processing the rest of the data.  I do not want to correct the data so i simply send it to a reject table. What I have not been able to find is if there is a way to remove the warning sign that appears on the Destination Task itself.  I assumed it would have gone away when i redirected any failures...i was wrong.</p>