Can we handle errors (Records failed to insert into target table) at OLE DB Destination?. If so I'm assuming we can re direct records which duplicate primary keys to error destination.
Yes you can. You cannot use fast load. You configure error output to redirect row. Then you can output to another destination. Contact me and I will send you a script I am using.