Generate ssrs powerpoint reports in ssis control

Aspose.Slides Product Family
1

Currently we're are using a SSIS control to generate SSRS reports.
With this SSIS control we can generate reports in the standard SSRS export formats (eg pdf, tiff, etc)

Is it possible to integrate Aspose into a SSIS control to generate pptx reports? And if so do you have a example of this?

2

Hi,


Thanks for your interest in Aspose.Slides.

I have observed your requirement and regret to share that currently the support is not available for Aspose.Slides to be able to get it self integrated with SSIS Control for exporting reports. An issue with ID SLIDESREP-33279 has been created as new feature request to further investigate the requirement shared. This thread has been linked with the issue so that you may be automatically notified once the feature support will be available.

Many Thanks,
3

Hello.

Could you please give us more info about your scenario? How do you use Reporting Service with SSIS? Maybe documentation links or example.

4

Hello,


Please check link for the scenario we use:

Generate SSRS Reports in SSIS – Control Flow – 2 of 4

Kinds regards,

Roald

5

Hi Roald,





Thanks for sharing the details about the scenario with us. I have updated the issue status with scenario shared. I will share the feedback with you as soon as the issue will be resolved.



Many Thanks,

6

Hi Mudassir,


Thanks again for the swift reply.

I’m going on holiday and will be back on 24-3. Then I’ll come back on this matter.

Regards,

Ronald Traets
7

Hi Ronald Traets,

Have a nice vocations. We will share the feedback with you as soon as it will be shared by our development team for requested feature support.

Many Thanks,

8

Dear Mudassir,


Could you give me a update about the status of this post?

Kind regards,

Ronald Traets

9

Hi Ronald Traets,

I have verified the issue status from our development team and regret to share that the issue has not yet been resolved. We have scheduled it for investigation during Week 16/2014. I will share the feedback with you after the investigation will be carried by our development after the requested specified time span.

Many Thanks,

10

Dear Mudassir,


In your previous post you mentioned the investigation was scheduled for week 16.
Since this was previous week, could you give me a update about the status of this post?

Kind regards,

Ronald Traets
11

Hi Ronald Traets,


I have verified the issue status from our issue tracking system and have also discussed the same with our development team. We are still investigating the requirements and will share the feedback with you as soon as it will be shared by our development team.

I will appreciate your patience in this regard till the time our development team share its feedback after completing investigation.

Many Thanks,
12

Hi Ronald Traets,


We have investigated the requirements on our end. It isn’t related with Aspose.Slides for SSRS functionality or an issue in product. You are actually looking to setup the non-standard saving of SSRS reports to a database. Aspose.Slides for SSRS is installed as standard Rendering Extension. This allows to use it as any other rendering format extension.

Also, have you tried to change a report description in database? It is possible to change the value of the FieldType field to “PPTX” and the value of the FileExtension field to “.pptx” (or any other PowerPoint format supported by Aspose.Slides) in the script. This may prove helpful on your end. You can please try the suggestions on your end and share your feedback with us along with all necessary information and data for further investigation if possible on our end.

Many Thanks,
13

Hi Mudassir,


Obviously I’ve allready tried to adjust the FieldType and FileExtension to PPT(X) and .ppt(x) the first time I had this problem. This didn’t work then and it still doesn’t work now. The following message occurs when I try to execute the script task with the rendering extensions that Aspose should support:

Error: 0x1 at Script Task: System.Reflection.TargetInvocationException: Het doel van een aanroep heeft een uitzondering veroorzaakt. —> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: You have attempted to use a rendering extension that is either not registered for this report server or it is not supported in this edition of Reporting Services. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: You have attempted to use a rendering extension that is either not registered for this report server or it is not supported in this edition of Reporting Services.
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
bij System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
bij System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
bij ST_a1fe6add6eee4fd8810027882cc7c2b8.vbproj.localhost.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
bij ST_a1fe6add6eee4fd8810027882cc7c2b8.vbproj.ScriptMain.Main()

So in my opinion the problem is related to Aspose.Slide since the Aspose.slides is registered on the report server and since the rendering extension should be supported by Aspose.slides.

Could you or/and the development team please have another look at this problem, because I have posted this problem almost a year(!) ago and I really need a solution for this problem since this function is crucial for our business.

Kind regards,

Ronald Traets



14

Hi Ronald Traets,

Thanks for your further feedback. I have shared the information with our development team and will share further feedback with you as soon as it will be shared by our development team.

We are sorry for your inconvenience,

15

Dear,


Could you please give me a update of the status of the problem. It’s been a while since I’ve heard from you and it’s becoming a real problem for our business.

Do you have any idea how long it will further take to solve this problem?

Regards,
Ronald
16

Hi Ronald,

Our development team has observed the stack trace shared by you. The last error message shared by you doesn’t contain any Aspose.Slides error stack info, but contains following lines

“You have attempted to use a rendering extension that is either not registered for this report server or it is not supported in this edition of Reporting Services.”

It is possible to find following articles about this issue.

  • http://www.infragistics.com/community/forums/t/77426.aspx
  • http://danieladeniji.wordpress.com/2011/12/28/microsoft-sql-server-reporting-services-error-unsupported-rendering-extension/
  • http://www.behindthecode.net/wordpress/how-to-modify-reporting-services-csv-export-behavior/

So on the basis of shared information they have reached conclusion that the issue is related with server configuration.

Many Thanks,

17

I have researched various forums,blog and website and got one relevant site. Where They have provide complete package to Generate SSRS reports in SSIS . AND You will also get sample work with snapshosts and all the things is explained in well proper way. There are various features of that package. Here I am sharing some of those.

  1. Automate reporting service 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,XML,MHTML and CSV format.
  6. Send report as attachment to list of users.
  7. Support for data driver export process. You can configure reports, recipients, file format and many other option inside database table to drive your automated export process.
    8.Support for SQL Server 2005,2008,2012,2014(32 bit and 64 bit).

To see more about task you can visit here

18

Hi,


Thank you for posting.

I have observed your comments but I am unable to understand it completely. Please share in which context have you shared your findings with us… Are you requesting for a feature or some new product. I request you to please make a new post over this link so that we may investigate it further to help you out.

Best Regards,