I have a data driven subscription which runs a reporting services report and generates the results as a csv file.
One of the field values inlcudes a double quote : Bread Tortilla Flour 10".
In SSRS 2005 this is correctly extracted to the csv as "Bread Tortilla Flour 10""". That is the value is placed in double quotes and the double quote itself is balanced with a second.
In SSRS 2008 this is extracted as "Bread Tortilla Flour 10"" which leaves an unblanced quote and makes the rest of the file unreadable.
Is this a bug - or do we have an incorrect setting. The report has been migrated directly from 2005 to 2008.