Is it possible to export data automatically from reporting services ?

Hi,

I want to export data from the result of a report in an SQL Table.

Anybody Knows if this is possible in Reporting services (may be with embedded code )?

Thanks for your help.

What do you want to export it to? If it is to a text file or Excel spreadsheet, then you can setup a SSIS package and run it via a SQL job to export your data automatically.

Hi J013,

Thanks for your useful answer.

Do you know if it is possible to execute a ssis package (or batch file) from an ACTION (or CODE) in Reporting services ?

Best Regards

Open Access

Good question. I am not sure. You could probably program something in ASP.Net to execute a SSIS pacakge and embed that into the report, but I have not read anything about executing SSIS packages from within SSRS being inherently built into SQL.