asked
Database Email
I have to create a process where I am pulling data from two different systems based on dates and matching employee names. Then, I will send an automated email to functional managers based on the matches. What's the best way to handle this with SQL database?
One possible approach is to creat a [linked server relationship][1], then create the procedure to generate the lists for each manager and use [database mail][2] to actually send the mail wtih your result set. If you are sending different result sets to different managers, you may need to put it in a loop to get all the relevant managers. [1]:
http://msdn.microsoft.com/en-us/library/aa213778(v=SQL.80).aspx [2]:
http://msdn.microsoft.com/en-us/library/ms175887.aspx
You could join the data (sorted) from the two servers together in SSIS with a Merge Join Transformation and send the appropriate emails from there. [
http://msdn.microsoft.com/en-us/library/ms141775.aspx][1] [1]:
http://msdn.microsoft.com/en-us/library/ms141775.aspx
Thank you for your input KenJ! We have many SSIS solutions here and the Team has been complaining about the errors. I would like to try two options. One, SSIS package and the other using Managed Extensibility Framework and possibly create a UI for administration and displaying errors.
