February 27, 2009 at 12:28 pm
I have an SSIS package. It updates a table in SQL Server 2005 database. There is another SSRS report that presents my final table and I run it and export it into Excel.
Is it any way after SQL Query task and Store procedures are being finished in my SSIS package, I add another object to run my SSRS report and export it to Excel format?
August 30, 2012 at 2:05 pm
July 24, 2013 at 12:45 pm
Hi,
If i want to connect to remote report server what would be the execution server name in the code you have in your blog:
Dim objRSExec As New localhost.ReportExectuionService()
In script code it says "localhost.ReportExectuionService() is not defined" How do we add it?
July 24, 2013 at 12:45 pm
Hi,
If i want to connect to remote report server what would be the execution server name in the code you have in your blog:
Dim objRSExec As New localhost.ReportExectuionService()
In script code it says "localhost.ReportExectuionService() is not defined" How do we add it?
July 31, 2015 at 1:55 am
Hello,
I have SSIS report service package task. Where you can get following:
1.Automate reporting services report export and email process using SSIS.
2.Support for SSRS 2005/2008/2012.
3.Support for Local report which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
4.Support for Sharepoint Integrated Mode.
5.Export report in xls, pdf, doc, xml, mhtml and csv format
Send report as attachment to list of users
6.Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process
7.Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit).
For more task detail you can follow this link SSIS Task for Reporting Services[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply