SSIS Package that Uses SSRS Report

I have a web site that contains XML documents.? I generate print versions of these XML documents by applying XSLT to the XML and rendering a .pdf version of the report with SQL Server Reporting Services 2005.? This report works now but the only way I currently know to run the report is URL integration into an application that uses Forms Authentication.? So the reports are rendered by a user clicking a URL.

I need to create a SQL Server Integration Services package that will perform three primary functions:

1.? Retrieve summary data from a data base for specific XML documents.? For example, retrieve the author, ID, and date for all XML documents created today.

2.? Call the reporting services web service to run the report that renders the XML into .pdf.? Save the report with a name that combines the summary data collected in step 1.? (eg [url removed, login to view]).

3.? Submit the .pdf to an eFax web service so that the .pdf can be faxed to a specific phone number collected in step 1.

I have an installation of the SQL Server Reporting Services web service that can be used for development purposes.? This instance includes the report that will render the XML into a report.? I can provide a backup of a data base that contains the summary data.

If you’re interested in bidding on this project, please outline your experience with SSRS and SSIS.? Please also outline your approach (for example, will you use a web service task or write a script to do all the web service calls).


## Deliverables

I have attached a description from

[[url removed, login to view]][1] on how to send a .pdf to eFax.? Please review this information as I don't think a simple SSIS web service task is going to work as the mechanism to send eFAX a document to fax.?

* * *This broadcast message was sent to all bidders on Friday Feb 15, 2008 11:02:28 AM:

I added a zip file to the bid request that outlines the approach to submitting a .pdf to the [url removed, login to view] fax service. Its not as simple as I first thought. So please review this document to see if you need to modify your bid. And if you don't think the efax step can be accomplished with an SSIS script task (or something else in SSIS), please let me know if you still want to include that step in your bid.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software

Veja mais: www how to write a report, uses of php in web development, ssrs architecture, sql functions pdf, software development project description example, service rendering, reporting software review, reporting services sql, renders service, render software, render a service, i want t be an author, how to write simple report, how to write report pdf, how to write a summary report, how to write a simple report, how to write a project report, how do i write a report, how can i write a report, file service architecture, create id use all web, architecture rendering service, ssis and ssrs, sql integration services, how to modify pdf file

Acerca do Empregador:
( 0 comentários ) India

ID do Projeto: #6843445

4 freelancers are bidding on average $5695 for this job


I have more than 5+ years experience in MSBI(SSRS,SSIS) Technologies and completed more 15+ projects successfully in

$5557 USD in 24 dias
(37 Comentários)

Dear Sir , Thanks for the interesting project. We can complete full process using SSIS project (read XML data , generate pdf using ssrs and submit to eFax web service ) We have all the features to complete it u Mais

$5555 USD in 30 dias
(6 Comentários)

Hello, My name is Sandeep Rawat, having 11+ years of experience in Software development, Application Management, Project Management etc. We have expert team of Mobile application development, Web portal developme Mais

$6666 USD in 45 dias
(1 Comentário)

I do have strong experience in creating SSIS packages. I have done MSBI for various multinational client. Please check my profile at linkedin: [url removed, login to view] Also, I have been Mais

$5000 USD in 20 dias
(0 Comentários)