Plain ASCII Text? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Plain ASCII Text?

I need to extract some data from SQL using a stored procedure that I’m running from a SQL job. I have it set to write the results to a text file. But, I’d like to ftp the file in text mode and download it in text mode…. It appears that SQL is only writing the file in Unicode, and the data gets messed up unless it’s transferred in binary. Any ideas on how to make it write data to plain ASCII text?
You can either use BCP or DTS in order to accomplish this task, refer to books online for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yeah, I ended up using DTS instead. I searched quite a bit on the web, but it looks like there’s no way to change it, so that’s the way it will have to be…
I would choose BCP than DTS in this regard. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>