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.