bcp to CSV

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  June 1, 2009 at 12:44 am

  #132390

  Is it possible have the column headers in CSV File by using BCP.

  Please help me.

  🙂

• GURSETHI

  SSCommitted

  Points: 1912

  More actions

  June 1, 2009 at 1:16 am

  #1002581

  Hi,

  Please go thru this link. I am sure it will help you out.

  http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  June 1, 2009 at 2:52 am

  #1002609

  thanks,

  but it is long process, so i have tired with the import/export, but it is saying that validation error. could u please tell me why it's happening.

  🙂