Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

using bcp to create an xml format file Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 3:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 11:15 AM
Points: 4, Visits: 30
hi all,
i'm creating this bcp command line to create a format file
bcp "SELECT id_s, date, log_type, query, user, Sito FROM Log" format nul -n -x -f "log_format.xml" -S .\SQLEXPRESS -T -e "errors.err"'

but the result is the error:
"An error occurred while processing the command line"

what is wrong about my command?

Post #601229
Posted Wednesday, November 12, 2008 7:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 11:15 AM
Points: 4, Visits: 30
ok, sorry
the format fle has no input query but only a table like this MyDB.dbo.MyTable
thanks
Post #601336
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse