format file with bcp command

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  June 1, 2010 at 5:43 am

  #225203

  I need to create format file with bcp command. i have no idea for this...

  can any one please help me on this..

  thanks in advance.

  Nithiyanandam.S

• Nagesh S-432384

  SSCrazy

  Points: 2231

  More actions

  June 1, 2010 at 5:48 am

  #1174725

  Can you be bit clear with what format you need, which will help people to answer.

  Nag

  Nag
  ------------------------------------------------
  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537

• Lowell

  SSC Guru

  Points: 323518

  More actions

  June 1, 2010 at 6:03 am

  #1174726

  this question i think you could have found directly from SQL Server Books Online or Google.

  bcp AdventureWorks2008R2..MyTestFormatFiles format nul -c -t, -x -f myTestFormatFiles.Xml -T

  http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Paul White

  SSC Guru

  Points: 150467

  More actions

  June 1, 2010 at 6:52 am

  #1174745

  In case you want to create an XML format file, or are using a later version than 2000, please see these Books Online links:

  Creating a Format File

  Importing and Exporting Bulk Data by Using the bcp Utility

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi