Select the OLEDB Source and set ValidateExternalMetadata Property to "False". By default it is "True"

My code is working fine as of now.. But I am trying to test the scenario for trigger failure and trying to capture the records which did not get inserted

As of now Trigger is working fine..

But I am deleting one of the column from the backoffice table and checking for trigger failure conditions..

The payment info from UI enters the Payment master table.. I created CDC on the master table.. So once the record is inserted in to Payments Master Table, the record...