137 Export data to csv file with header using bcp command

Export data to csv file with header using bcp command
Download the file\script used in the Video from below link

Export data to csv file with header using bcp command
How do I save SQL results to CSV with headers?
How do I export a SQL header?
How do I export data from SQL Server to CSV query?
How do I export query results from SQL Server Management Studio to CSV?

[Fabiofasdgfgf]

This is a brilliant way to export data! Thanks a lot for sharing this info and the script. I have tested and it is working fine to download a single table though I am running into trouble when trying to do it for 2 tables. Am I missing something?

It returns me an error: Unable to open BCP host data-file

I have tried several options but it looks like I can't figure this out.

I know I can create n-bat file one for each table but I'd really love to have all in one place, easy to control

Please let me know if you can advice on this

[logohackz]

Hi aqil, your teaching is awesome, I have a one question if we have a flat file having 105 records, we have to split that into 11 sheets. Every sheet has 10 records and last sheet has 5 records how can we do that?

[suriaraopayadathalie]

I tried, but the the step did not generate any output from job scheduler

[karthikkunala]

Hello Aqil, so while exporting to txt file or csv file if we go to advanced tab in the connection manager, we can name each and every column and enable the option "Column names in the first data row". This can also solve the problem right rather than this script?

[devakumar]

How to export data to shared path? When I am doing this I am getting error like: Unable to open bcp host data- file.

[sarahelen]

Do you know how yo do it but to an Excel file? I mean not a CSV, I need a .xls file, and not using the export tool wizard nor SSIS. I did it in the past but I don't remember well, I think it was with bcp or OpenRowSet, ¿do you know those solutions? Thank you

[jeffersonromario]

AND IS THERE A SCRIPT TO DO IT DIRECTLY IN A PROCEDURE? I AM STRUGGLING WITH IT AND I CAN'T FIND ANY SOLUTION.

[vaibhavsrivastava]

Hi sir,
My data is not coming from a single table it is using 3 table and join to get data ...now I am able to export data in Excel but how can I add header to the file

[muraliuppara]

Hello Bro,

Assume there are 1 lakh records in sql table . I want to split the data into 10 csv files with 10k rows/file using BCP Command. how we can do this .can you explain with brief

[kishore]

I want a method to export all tables in db to csv at once please help me to achieve that 😔