Save Scheduled report output file to database table through custom delivery extension
Hi,
We are using SQL Server 2005 reporting services. We are having a requirement to save the scheduled report out put file directly to a database table in oracle. I looked at custom delivery extension for Print Delivery and found some help.
I am stuck at point of saving the notification.Report.Render("PDF", null); to database table. I am not sure how to save the output of the Render method i.e RenderedOutputFile[]
to database table.
Any help in getting started is appreciated.
Regards,
Ashwin
ashwin
June 7th, 2012 5:46am
Hmm, never done it. But perhaps you can create a linked server to Oracle and insert the data (generated EXCEL) directly into Oracle database?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
June 7th, 2012 5:48am
Hmm, never done it. But perhaps you can create a linked server to Oracle and insert the data (generated EXCEL) directly into Oracle database?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
June 7th, 2012 6:03am