'Identity Insert Off' Not Detected, Validation Error

I am trying to capture the rows that fail during an insert.



The insert is an OLE DB command component.

I have config'd errors to redirect to a flat file.



My problem is this

I need to override the identity, fine if you are using 'fast load' but then you can't capture the redirected rows.

So I am using the regular 'table or view' data access mode, but then I lose the 'keep identity' checkbox.



At this point I add in another OLE DB command "SET IDENTITY_INSERT table OFF" before the actual insert ODB component.



But now it won't validate. I changed the task 'delay validation' property to true, but still it is failing.



It seemingly cannot detect this statement.



So how then can I capture error rows from an insert where I need to switch the identity off?



[This is a one off historic load I am working on]