dbTalk Databases Forums  

How can i send an alert email

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How can i send an alert email in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mint
 
Posts: n/a

Default How can i send an alert email - 07-10-2006 , 01:05 AM






i want to make a package, that it can get how many rows in a table.
when the table get a new record. the dts will send an alert to the
admin, or the record deleted, it will also send an alert to the admin.
how can i do it.
please give me some advices.
thanx.


Reply With Quote
  #2  
Old   
Davide
 
Posts: n/a

Default Re: How can i send an alert email - 07-11-2006 , 02:32 AM






Hello Mint,

Quote:
i want to make a package, that it can get how many rows in a table.
when the table get a new record. the dts will send an alert to the
admin, or the record deleted, it will also send an alert to the admin.
how can i do it.
please give me some advices.
thanx.
It seems a strange use for a package; would not be better the use of triggers
on the table which interests you?
Bye




Reply With Quote
  #3  
Old   
Mint
 
Posts: n/a

Default Re: How can i send an alert email - 07-11-2006 , 10:04 PM



thanx
i will make a try.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.