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.

All Forums  Old Forums  CLOSED - General SQL Server  osql - spaces and extra lines in text files

Author  Topic  paulh Starting Member 1 Post Posted - 2001-09-28 : 03:51:27 I've been using osql and os execute strings to generate text files from within a tsql stored procedure. (pretty much in the same way as Garth's article on this site.) This works fine, but there's an extra space at the start of each line in the file, and an extra line or marker at the end of the file. How can I get rid of these, because they confuse the systems that receive the files.