Home All Groups Group Topic Archive Search About

SSIS Notification Services

Author
26 Sep 2007 12:14 PM
walter1234
I have a question about SSIS Notification services.  If this is not the
correct - ng, please let me know which one to use.
I have an SQL2k database with a number of actionable dates, e.g. due dates.
expiration dates and so forth.
I would like to set up an alert system so that specific individuals are
notified by email when when a date is 30 or 45 days before its date.
I also need to put a "todo" item into the outlook/exchange mailbox for that
person
Is this something that I can do with Notification Services?
Will it work with MS-SQL2k or would I have to upgrade to SQL2005?
Thanks for the input

AddThis Social Bookmark Button