Bulk Copy into CSV file with column name

Bulk Copy into CSV file with column name

• Mario Queiroz

  You can't do it with bcp.  You can either add the columns by hand, or write some fancy SQL to retrieve the column names from the syscolumns table.  You'd probably have to do it in a DTS package.
  

• Julianín

  You can use a query that contains the header row and orders the data appropriately. See http://www.umachandar.com/technical/SQL70Scripts/Main8.htm for an example. Note that with this approach you will have to convert all the data to string format.
  
  
• Bulk Copy into CSV file with column name