• Your proposed solution will not work, because the DELETED table is only a psuedo table available to the trigger. Your BCP will start using another thread and will not have access to the DELETED table.

    You could copy the contents of the DELETED table to another permanent table, and then run your BCP against the permanent table.