I have a requirement from my customer. They are migrating to the SSRS from Excel Reports. Currently they have a SSIS Package which will get the columns needed from the database to the excel sheet and the business users are asked to look into that report. They asked to do the same report in SSRS and email it to the customers.
For the above problem I can have 2 type of solutions:
1) Accessing the data directly from the source of the SSIS.
If your source database is OLTP system and running the Data Source will affect the performance of the Database.
2) Using the existing SSIS package as the Data Source of the report.
When I was searching for this functionality, my friend told me about the possibility of doing it. He asked me to change a couple of config files and you can use the SSIS package as your Data Source of the report.
Steps to Follow:
Follow below set if you need to set SSIS packages as data source for your reports.
1) Open RSReportDesigner.config file through text editor. It is stored in the \Program Files\Microsoft VisualStudio8\Common7\IDE\PrivateAssemblies folder.
2) Remove comment marks that have been set for SSIS extensions under data and designer element. Save and close it.
3) Open the rsreportserver.config file in the \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer folder.
4) Clear the comments marks for SSIS extension under data element.
I have already heard of using XML file as the Data Source to the Report. But you need to add a assembly in the report server level to do this.
I welcome your suggestions and views regarding the posts.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment