In general, I don't like calling web services (especially synchronous calls) from an SSIS box, because that ties the performance of the SSIS box to that of the client (the performance of this report). That said, if you proceed, you are going to want to call the Render method for your report and then email the results.