SSRS Report Builder - Export to CSV issue with extra Double Quotes

I created a report in SSRS to be used to generate a flat file for the printing of Product Labels in Bartender.  At the top of the report, I have a string of information that needs to be printed exactly as indicated below.  The line with a header of "Yours-" is what is currently displaying when you open the CSV with Note Pad and the line with a header of "Printer-" is what should be printing.  If I open the file in Excel, everything appears to be fine.  The only thing that changes is the Label Format field which is being updated from a SQL Table (it's the extension that ends in .btw).  

"%BTW% /F=""\\Sav2008\Sage\Label\MAS_SWK\format\format2.btw"" /D=""<Trigger File Name>"" /p /C=1 /DD /DBTEXTHEADER=3 /R=3 "

%BTW% /F="\\Sav2008\Sage\Label\MAS_SWK\format\WMS\WMS_format7.btw" /D="<Trigger File Name>" /p /C=1 /DD /DBTEXTHEADER=3 /R=3

I found an article online that told me to modify the following information in the rsreportserver.config file but it appears to not have solved the issue.  I need to have the code in there to remove the headers but am not sure about the rest or if I need any additional code to get the "" from showing up when there only should be one ".

      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
         <Name Language="en-us"> CSV No Header</Name>
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
From a question on
The renderer adds quotes (called "qualifiers") around values that contain the field delimiter character. Since the default field delimiter character in the CSV renderer is a comma, you will see qualifiers around any data value that contains the comma. ... You could change your field delimiter to something different (see DeviceInfo documentation for the CSV renderer) in order to get around this.
In short I'm not sure SSRS is the best way to go. Have you looked into a bulk export directly from SQL?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rm103Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.