Unanswered: Rougue CR/LF in my bcp output flat file!?!?!
The following bcp command is present in an NT job I have scheduled each day
My trouble is that every 2034 characters the output contains a :0D:0A (CR/Linefeed).
bcp "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"
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???
Non est ei similis.
I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them