Writing from SQL Server table to file using BCP

Question

I just realized my caps was on from working in SQL Server, ha.

Anyways, Im trying to write from

serverName.databaseName.databaseInstanceName.TableName

to

C:\FileName.xml

using bcp and I want to write only columns Col1 and Col2, could I get a little syntax help? I'm struggling over here.

Thanks,

Ted

Answer 1

In order to create an XML version of the format file the command is identical except we use the -x parameter.

bcp "SELECT col1, col2 FROM AdventureWorks.HumanResources.Department" format nul -c -x -f department.xml -T -S servername

Answer 2

thanks, I did google it myself, but again struggling with the syntax. Thats why I put the embolden terms above. I've got it to:

bcp "select col1, col2 from db.dbInstance.Table" format nul -c -x -f c:\test.xml -S localhost -e C:\error.txt -U AD\username

but after I enter my password, all I get is

"An error occurred while processing the command line"

Answer 3

FYI for anyone else....

bcp "Select whatever from dbInstanceName.dbo.tableName" quesryout C:\output.txt -e C:\errors.txt -c -T -S localhost\dbName