Multi Line output column

• jyz

  SSChasing Mays

  Points: 613

  More actions

  December 1, 2011 at 8:46 pm

  #247736

  Hi ,

  I have a requirement to show an output with new line breaks in one of the output column. This is not possible in sql server 2008 Grid output. But i got the output when i set the result as text.

  Now I would like to know whether i can extract this result, with the same format with new line, and save it to a text or .csv file ( by any method,dts or ssis).

  Any help would be really appreciable.

  Thanks in advance

  Jeyis

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  December 1, 2011 at 9:20 pm

  #1415679

  please don't cross post

  all replies here please: http://www.sqlservercentral.com/Forums/Topic1215104-391-1.aspx