Currently I have several machines that output data in a CSV file. I'm putting a system in place to import this CSV file into a SQL Server database using SSIS. Once the data resides on the SQL Server I would like to then display the data as a report (preferably SSRS), however the hangup I'm having is my end users then want to modify the data displayed in the report and then re-upload this finished report into the database. Ideally I leave the raw data in its raw format and store any modified data separately. What are some potential methods for accomplishing this?
You could write a custom app instead of SSRS that displays the report in an editable data grid.
You could also create a custom app that lets users import data via excel, so if they export your SSRS report to Excel, they can edit the Excel doc and then upload it to save their changes to your database.