Robert O'Byrne (9/18/2007)
When using Reporting Services tasks to export to a flat file destination you have to create a <U>Flat File Destnation Task</U>. This task needs a <U>Flat File Connection Manager</U> to tie into you destination file. You can find this checkbox in your <U>Flat File Connection Manager Task</U>. Check the box if you want to include a header row. Uncheck it if you do not want to include a header row.
<IMG alt="Uncheck Header Row" hspace=0 src="file:///C:/Documents%20and%20Settings/ROByrne/Desktop/UncheckHeaderRow.JPG" align=baseline border=0>
I have just uncovered this thread whilst searching for a solution to removing the column headers from a Reporting Services export to .CSV file.
From what I can see the answer given by Robert O'Byrne is still related to SSIS NOT SSRS. Does anybody have a solution of how to exclude the header row being included when data is exported from a report to a .CSV file please? Exporting to .XLS or .PDF works fine and does not include the column headers!
If anybody could advise or point me and the OPer in the right direction it'd be greatly appreciated