SSRS: Options for Exporting
Posted on 2014-04-14
Although it might seem more logical to use SSIS instead of SSRS for this project, I'm going to use SSRS.
Ultimately, what I'd like to do--once I have my report created--is to export the data from SSRS to a text file.
I know that there is no such direct export available. So, I will export to Excel and then save the Excel spreadsheet as a text file.
Now, the SSRS report is going to be pulling from at least one view in the SQL database. And, that view is going to format fields to contain column lengths. Retaining these column lengths is very important.
So, if I export to Excel and then save as text, will the column length formatting be saved?