We have a daily report in our environment which we generate and email through SSRS. Now recently, we added few more environment and they are not running SSRS on them.
The problem is that in order to write the report in the same format (which has server wise details and couple of work sheets) SSIS (and other alternatives) seems to be unusual.
Our format of the report is fixed so that we can use the file as a template but I am not sure how to force the data (from SSIS) to write in a specific cell of the excel sheet.
Can somebody suggest any direction or any other alternatives?
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]