How to copy table content before deleting to flat file using BCP
As scsimon has pointed out, you can take advantage of OUTPUT clause instead of using a flat file.

CREATE TABLE MyTable(id int identity, foo int);
CREATE TABLE MyTableDeleted(id int, foo int);

INSERT INTO MyTable VALUES
(100),(200),(300),(400),(500);




DELETE FROM
    MyTable
OUTPUT
    DELETED.* INTO MyTableDeleted
WHERE
    foo &lt;= 300;




SELECT * FROM MyTable;




id | foo
-: | --:
 4 | 400
 5 | 500



SELECT * FROM MyTableDeleted;




id | foo
-: | --:
 1 | 100
 2 | 200
 3 | 300