July 9, 2008 at 9:47 am
I have a SQL database that contains an account table. The account table has among other information a users name, user ID, password and email address. When a record is added to that table I would like to use the Send Mail Task to send an email to the user with their user ID & password. Does anyone have suggestions on the best way to go about that?
Thanks!
July 9, 2008 at 12:54 pm
Did you try to use triggers?
July 9, 2008 at 1:04 pm
A trigger would probably be a better solution to this than SSIS. With SSIS, you would have to schedule a process to check the table for new entries - which would mean you would have to be able to figure out that an entry had not had an email set for it.
A trigger would be real-time and based on the event of the insert. If you use sp_Send_DBMail, it queues and uses service broker, so email being down will not interfere with data being added.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply