Trigger an Email of an SSRS Report from an SSIS Package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stan Kulp » Trigger an Email of an SSRS Report from an...

17 posts, Page 2 of 2

««1 2

Trigger an Email of an SSRS Report from an SSIS Package

Rate Topic

Display Mode

Topic Options

Author

Message

dcdanoland

Posted Tuesday, March 19, 2013 9:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 2:51 PM
Points: 25, Visits: 117

Mister Magoo,

Thanks for shedding some light on AddEvent. To be honest, I prefer my Oz mysterious and behind the curtain; I don't want to know how big of a sham it is. You have a database storage engine shrouded in complexities. I grasp Kalen Delaney's explanations on the same level as quantum mechanics - sort of, kind of, but not really. Then you have parts like of the Report Server that feel like they were hacked together by college juniors cramming on a take-home final. Don't get me wrong - Reporting Services is pretty solid now. But thorough documentation would make me a lot more willing to make database calls under the cover.

-Dan

Post #1432748

rnjohnson10

Posted Tuesday, March 19, 2013 7:55 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 5:08 AM
Points: 13, Visits: 137

I do this with shared schedules.

I've got about six shared schedules which are triggered at various times in my etl process.

I have a stored procedure which is triggered with a parameter indicating which shared schedule should be executed. The proc then reads the db to find the subscriptions associated with tht schedule and does this add event trick.

That way, we only have to assign a report to a shared subscription and it will go, no extra set up necessary.

It's been very stable for a couple of years now.

Honestly, this really shouldn't be so difficult a task to manage. It should be base functionality of the product to make ths process easy. No one dealing with etl processes is going to be able to schedule a report at a given time and be assured the data will be ready.

Post #1432974

Koen Verbeeck

Posted Wednesday, March 20, 2013 1:56 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 9,367, Visits: 6,463

Very useful article, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1433046

nahk.fussuy

Posted Wednesday, March 20, 2013 6:30 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 7:29 AM
Points: 51, Visits: 236

Nice article. I did a similar thing a few years ago using shared schedules. Avoids hard coding the GUID into stored procs.

I wrote it as one big mad post on the forums:
http://www.sqlservercentral.com/Forums/Topic576337-150-1.aspx

It describes how to setup shared schedules for the 'events' you want to trigger reports.
I then use a synonym to point to the report server. A new stored proc "runReportServerSchedule" is created that takes an 'event' name aka 'shared schedule' name.

Then all you do is subscribe reports using the shared schedule names and in your SSIS packages call the runReportServerSchedule with the schedule names as required. I used this in several systems with great success to allow users to get reports when data loads complete, fail, have validation problems etc.

Give it a read.

Post #1433172

Stan Kulp-439977

Posted Saturday, March 30, 2013 6:49 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 78, Visits: 597

Does this answer your question?

http://stackoverflow.com/questions/3471821/how-to-pass-a-parameter-to-ssrs-report-from-ssis-package

Post #1437259

Jeff Moden

Posted Yesterday @ 8:00 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:30 PM
Points: 32,893, Visits: 26,770

Hey Stan,

I just looked at your article and almost all of the graphics are coming across as solid blue boxes with a little red "x" inside a smaller box at the top left of the larger. Not sure if it's just my system or if the article code actually has a problem but I thought I'd give you a heads up.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1454301

Stan Kulp-439977

Posted Yesterday @ 9:14 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 78, Visits: 597

I believe that the sqlservercentral.com server is having severe issues. I have been writing an article and can't modify it or add or delete resource files. I had the web administrator upload a file for me last week, but now I need to change it and can't.

I will email them again on Monday.

Post #1454304

« Prev Topic | Next Topic »

17 posts, Page 2 of 2

««1 2

Permissions