SSIS Redirect when fast load option is turned on

Error Message
The error row disposition on "input "OLE DB Destination Input" (339)" cannot be set to redirect the row when the fast load option is turned on, and the maximum insert commit size is set to zero.

I recently came across this error while using the redirect option within the data flow tasks. The message is fairly self explanatory, but finding the change can be a little tricky. To make take you flow out of fast load mode you need to access the properties of the OLE DB Destination, and change “AccessMode” to only OpenRowset.

If you want to leverage the fastload option you can also get around this by changing the property FastLoadMaxInsertCommitSize from 0 to a different transaction size, which is a better way to go anyway.