Hi !

How does one run a reporting services report from within SSIS?

The report will either email the resulting reporting output, or write it to a file.

What I've found so far is that there are two ways of doing it:

a) Add a Script component to SSIS to handle the report call.
b) Call RS.EXE from Execute Process (probably) to run the report.

I would much rather want to go the a) route.

Is that the way to go?

Are there any code samples out there that can help me ?

Regards,
Palli