when i tried using \r\n in my select and creating the text file thru .Net, nothing was happening
select
'line one | \r\n' + 'line two | \r\n'
so i found this
Declare
@CrLf
char (2)
SET
@CrLf = char(13) + char(10)
select
'line one |' + @CrLf + 'line two |' + @CrLf
and this seemed to work. Thanks Butch. here is the entire link
http://www.sqlservercentral.com/Forums/Topic450843-23-1.aspx