The following bcp command is present in an NT job I have scheduled each daybcp "EXECUTE DailyProd.dbo.GetIndexComponentStocks_XML '2006-04-05'" queryout "D:\TABLES\INPUTAP\IndexComponentStocks.wrk"
-S(local) -c -T -o"..\IndexComponenet_XML_LOG.txt" -e"..\IndexComponenet_XML_ERR.txt"
My trouble is that every 2034 characters the output contains a :0D:0A (CR/Linefeed).
Other than that all the output data looks peachy.
Is there some line size setting I am missing (would it be packetsize?)?
Ideally I would just like to not have any CR/LF in my file at all...is there some way to turn it off? I see there are flags to set to change the column and row terminators, but how to turn them OFF?
Thanks much!
PaulYup, just had to add the -r and -c flags without any character following them to turn 'em off.
Showing posts with label dailyprod. Show all posts
Showing posts with label dailyprod. Show all posts
Saturday, February 25, 2012
Subscribe to:
Posts (Atom)