How to run and email a report from SSIS

[Former Member]

Hi guys

I need to set up an SSIS package that will run a standard report and email the results.

I have sorted out the email side of the job, but need to know if/how I can run BPC reports from SSIS.

Has anyone done anything similar, or have any tips/pointers?

Thanks

Craig

[Former Member · Accepted solution]

Hi Craig,

I am little doubtful of this. I dont think we can open a template through SSIS.

[Former Member]

Thanks guys.

Looks like I might give this one a miss then.

I'm not going to try to do an impossible task, so I'll try to come up with a better solution.

@Patrick - The Distribution Wizard sends the email from the users own PC, and as we have firewalls and white-lists on our email servers that prevent SMTP unless the PC is named, I was hoping to send standardized reports from the server, to avoid having to manage dozens (potentially hundreds) of PC's in the white-list.

Edited by: Craig Aucott on Jan 28, 2010 1:40 PM

[PatrickFavre]

Hi Craig,

I have never done this, but I doubt this is something possible in a standard way, or if it's feasable, could be very difficult to set up.

In fact, BPC works over Webservices, and it should probably be possible to use an ActiveX task inside our SSIS package and code something in VB there, referencing some API...

In any case, why don't you use the Offline Distribution Wizard for that? It's doing exactly what you're expecting.

Kind Regards,

Patrick