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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-16 : 09:28:05
|
| Matt writes "Greetings! Warning, I'm a rookie. I wrote a stored procedure to pull data in order to do a nightly export/import from one system to another. I have a batch file that looks like this:bcp "exec WinSNAP_retrieveStudents '0607'" queryout c:\WinSNAPData06.txt -c -U user -P passwordSometimes, the file works and I get perfectly formed data, with everything just as I've requested (mostly basic demographic information: names, addresses, etc.).But, other times the output file contains nothing but garbage characters, like this:剒乏†††††††††ठ䅍啎䱅†††䴉㐉㐷‰䕓䄠䅐䡃⁅剄The file size looks right, but it contains nothing but characters like this from beginning to end. I can find no pattern as to why/when good data gets pulled versus the corrupt data. I can run the batch file one minute and get good data, and run it the next minute and it's all corrupt. We have the batch file scheduled late at night when no users are online, and I get the same results -- one day it works, the next it doesn't.Forgive me if this is a well-documented issue -- my searches so far haven't turned up a thing!Thanks much for any advice you can provide!!Matt SmithDeSoto County School DistrictArcadia, FL" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-16 : 11:57:19
|
| I'd look at 'collation'. You may be picking up a character set that you're pc/server is not set to recognise. Is this batch always executed from the same source PC? Could you be picking up different regional settings?Do you need unicode...ie foreign language support...? |
 |
|
|
|
|
|
BCP batch file produces sporatic corrupt data