SQLTeam.com | Weblogs | Forums

OLEDB source error redirect is not working

hi,

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

image

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

Also, added data conversion task, but no luck

image

Any suggestion will be very helpful

thanks

what is the error that it is returning?