I'm redirecting the error rows to error table in SSIS package. The problem is, if one row fails all the rows are redirecting to error table. I want to insert good rows in a different table and only error rows in error table. How can I do this? I know there is a property that needs to set to true but I forgot that property name. Any help would be appreciated.

Your destination should not be set to using Table or View - Fast load option, use just "Table or View".Arthur My Blog

Hi, You need configure batch size. I there are more than one row on batch, all of it are redirected to error output. Try to set 1 in Rows per batch or change Data Access Mode and set without fast load. RegardsVctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Thanks.