SQLTeam.com | Weblogs | Forums

OLEDB source error redirect is not working


I have around 80k records from a staging table to flat file, it giving error around 54k records. I am trying to check the records by redirecting the error into another error table


attached image for review, not sure why the error records are not getting redirected.

Also, added data conversion task, but no luck


Any suggestion will be very helpful


what is the error that it is returning?