File is getting generated into folder, But not a csv file
On your BCP command use the -t switch to specify which field delimiter you want to use
https://docs.microsoft.com/en-us/sql/relational-databases/import-export/specify-field-and-row-terminators-sql-server?view=sql-server-ver15