Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shankar666
Starting Member
1 Post |
 Posted - 2007-09-07 : 11:34:36
|
| Hi,I need to redirect the output from an SQL SP to a tab-delimited text file. I was using OSQL utility for batch job creation and output redirecting. But, here, I am finding that the output is only single SPACE delimited.I also tried using BCP utility as follows from a batch file:Call "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp" ##Temp_Table out "c:\rr.txt" -n -S TestServer -U admin -P pwd -t "\t" -r "\n"I am getting output file as Tab-delimited; but the last few columns are not correct and comes with Special symbols like Öø ð6 and š µ˜ etc...CAN ANYBODY HELP ME IN RECTIFYING THIS ISSUE? N.B: Am using MS - SQL 8.00Thanks in Advance,shankar |
|
|
|
|
|
Help Needed: Redirect Output to Tab-delimited File