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  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Remove blank lines from output file

Author  Topic  kencao Starting Member 2 Posts Posted - 2010-04-15 : 12:57:34 I have created a batch to create an output file with the SQLCMD utility. The query result has 3 records. But there are 2 extra blank lines added automatically to the file by SQL Server. Is there an option in the SQLCMD utility or in the Select statement to remove the extra blank lines?