There are around 10 records being loaded into table X and 5 are rejected at the file level. I want to delete those 5 records in the reject file from the table.

New contributor
Prajwal Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • How do you load this file? – Piotr Mar 23 at 14:16
  • Through an SSIS Package – Prajwal Sharma Mar 23 at 14:17
  • 1
    There is tens of ways to do it. Do you want to modify source file or just save incorrect records on the side? And please post exact error you are getting. – Piotr Mar 23 at 14:18

Browse other questions tagged or ask your own question.