Using BCP Command for Query Result set Data Export as File

This video is part of a SSIS Project - "Generate Extracts based on queries of a table"
In this video, you will learn how to use BCP Command for Query data export as a text file.
Please follow the playlist in a sequential order to understand the project better.
Thanks!

[@Dgprabhu]

Hi Sir ,
I have followed the same and all the records are coming in one column in .csv file . Did I miss any steps ?

[@kalaiyarasiBK]

How to exclude the last row using this command?

[@Casdias]

Good, but how to put the header in result!? 👏