Column names in header row have quotes - need the quotes removed RRS feed

  • Question

  • Environment:  Both BIDS 2005 and BIDS for SQL 2008 R2 (VS 2008 - 9.0.30729.4462)

    I've set up a simple data flow task to dump query results to a flat file (.CSV).  I figured out how to get the string/text data surrounded by double-quotes, but the setting also quotes the column names in the header row (I checked "column names in first data row").

    How can I get rid of the double-quotes just for teh column names?



    Tuesday, February 21, 2012 5:47 PM


All replies