That would possibly the same as DTS! Do you know of any step--by-step article on how to do this in SSIS?
Just out of curiosity, if I were to use SQL Server's Notification services, I'd be make use of SSRS(reporting services) as well, wouldn't I?
|||If you search the forum for "Send Mail", you should find some links. Also, it's really not a very complicated task to use.
I'm not sure why you are tying Notifiation Services to Reporting Services (or Integration Services, for that matter). They are seperate products, and while they can interact with each other, they do it the same way any external application would interact. For example, SSIS can interact with Reporting Services directly by calling the web service to generate reports (just like any other external application).
|||The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.|||
onamika wrote:
The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.
Neither of which are related to SSIS though.
From SSIS look at using the Send Mail task, or using a Web Service to handle notifications.|||Frankly, I don't see any SendMail tasks example or how create an example. Maybe it's because I'm faily new to MSDN.|||
http://forums.microsoft.com/MSDN/Search/Search.aspx?words=Send+Mail&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80
The second result returned has a walkthrough of using a Send Mail Task inside a For..Each loop. I didn't go through the rest, but I'm sure there are more examples.
|||
Frankly, I don't see any SendMail tasks example or how create an example. Maybe it's because I'm faily new to MSDN.
BOL has some information on the Send Mail task inside SSIS.
http://msdn2.microsoft.com/en-us/library/ms142165.aspx|||
The reason I mentioned reporting services because I read at a MSDN article that Analysis services uses Repoorting server for Notification Services.
Perhaps the nomenclature is a problem here. Perhaps it should be "notification services" rather than (the product) "Notification Services".
I'd like to read that MSDN article because if that is what it says then it is lying. Analysis Services does not automatically use Reporting Services for anything. You can deliver reports on top of Analysis Services using Reporting Services - but that is something else entirely.
-Jamie
|||
Frankly, I don't see any SendMail tasks example or how create an example.
Its very very very very simple. Just try it - witha little perseverance you won't need any documentaiton.
Maybe it's because I'm faily new to MSDN.
Not sure what you mean by this. What has MSDN got to do with this? How can you be "new to MDSN"?
-Jamie
|||I'd like to stick to the point - question about "SendMail" please!
Ok, bonus question for you. This is mostly text based mail I see. How can I make this email HTML based?
|||
I'd like to stick to the point - question about "SendMail" please!
Ok, bonus question for you. This is mostly text based mail I see. How can I make this email HTML based?
Drop the Send Mail task in the Control Flow tool box onto the work surface. Double click on it to configure it. From there, I think you should be able to figure out what to put where.
As far as HTML e-mail (WHY? WHY? WHY?), please search this forum for examples. This has been discussed before.
As an aside - HTML is VERY BAD design, in my opinion. HTML should be left to Web servers to display. If I had it my way (and many in the security community) e-mails would be limited to TEXT ONLY. Anyway......... That's my rant for today.
No comments:
Post a Comment