According to the book (p. 146), "The Fast Load options specifies that SSIS will load data in bulk into the OLE DB Destination's target table. Because this is a bulk operation, error handling via a redirection or ignoring the data errors is not allowed."

This feature is not documented in SQL Server 2008 Books Online and, when setting up such a destination, there is no restriction in selecting Redirect row or Ignore failure for the Error ouput.

An article I found on the net Optimising SSIS for Large Data Loads by Catherine Eibner states: "I try to use the FastLoad option when ever possible. I have seen a few articles that mention that you can't use Fastload or that you shouldn't use Fastload if you need to perform any Row redirection. I disagree."

So, can anyone enlighten me about this fact? Where does that statment come from? Or is this just "best practice"?

Thanks in advance for your input.

Luc