I want to capture source records that can't be loaded into target table due to data values being inconsistent with expected data types in the target.
My source and target both are teradata tables.
I am not sure what exactly you want to do. Please provide more details.
My assumption: If you are having source table with column data types which are different than the target table, and you want to ignore the "bad" records and load the "compatible" records to the target table, then you can use TPT + Named Pipe Access Module. In the data connector operatore defintion, you have an attribute which you can specify to ignore the "error" records.