sql server – MSSQL: backup data stored in a table

I need to make a backup of all the data stored in my table1 because after passing the value to another table, I am deleting this table. Is there any way to put in my query where a backup is made and it is automatically saved as a CSV file? (This is one way I can think of to back up my file).

So far, this is my code:
SELECT * FROM dbo.AA_WC_RAW_DATA_FINAL IN THE PROFILE & # 39; /tmp/orders.csv'
AREAS FINISHED BY & # 39;, & # 39; OPTIONALLY CLOSED BY & # 39; "& # 39;
LINES FINISHED BY & # 39; n & # 39;

I am receiving an error in the "INTO" part. It seems that this is a mysql code.