Multi Line output column

• jyz

  SSChasing Mays

  Points: 613

  More actions

  December 1, 2011 at 8:47 pm

  #248936

  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 Grid output(sql server prior to 2011 Denali). 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:18 pm

  #1415678

  please don't cross post.

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