use 'Data Conversion' in you Data Flow, try to convert the ID column in Int,

click Configure Error Output, on Error Column Change the Fail Component to Redirect Rows.

Create a another table for that and drag the RED flow to that table.