microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Sending file attachements using Email Notification

Subject: Re: Sending file attachements using Email Notification
From: Joe Webb
Date: Mon, 27 Jun 2005 06:59:24 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Mangesh - 

You should be able to use SQLNS to build an application that does
that. 

I'd start by building a basic instance & application that defines your
subscribers and events. Notifications at this point could be simply
written to a text file to prove the concept. 

Then you could develop a couple of custom components. The first one
would take the notification information and save it in the desired
output (pdf, excel, etc); this would be a custom content formatter. 

The next custom component would be a delivery protcol that would get
the document to the subscriber. The built-in SMTP delivery protocol
doesn't support attachments so you'd need to develop one that does. 

Having said all this, if you are not too concerned about the actual
format of the notification (in your original post you indicated pdf or
excel would be fine) then you may want to consider simplifying your
job and sending email notifications using the built-in XSLT transform.
Another possibility would be to use the HttpExtension that is provided
as an example with SQLNS. 

HTH....

-- 
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Sun, 26 Jun 2005 21:39:01 -0700, "Mangesh"
<[email protected]> wrote:

>Hi All, 
>I am new to SQL Server Notification Services and want to know if the 
>following is possible using the same. 
>I have a scenario where subscriber wants a data in excel or pdf format as an 
>attachment to the email notifications. The data present in the excel/pdf file 
>will be the latest data extracted from the database when the event occurs. 
>Can we achieve this by using SQL server notification services? Currently we 
>have customized email notification applications doing the same job. Please 
>advice and suggest. Thanks!
>
>Best Regards,
>Mangesh Thote


<Prev in Thread] Current Thread [Next in Thread>