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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics