Error code -1071607685, Redirecting all rows to error output SSIS
Error code -1071607685 for this description is NO Status Defined.
Here when we have Data Access Mode Fast Load with Maximum insert commit size specified. In this case, if any one row also gets an error due to duplicates or anything the entire batch gets redirected to the error output.
In another case, after the first batch committed and an error occurred in the second batch Then the entire second batch get redirected to the error output. To resolve this issue: 1) We need to set Table or View Setting 2nd screenshot so only error output will get redirected to Error table. 2) Set Maximum to insert commit size small, something like 10,000 or less, then if any error comes in that batch only that number of rows will go to error rejects.
See Also
SQL Server 2012 Release Notes
Power View Overview (en-US)
Primary page for information on troubleshooting SSRS issues and errors