Is it possible to use a 'Master' Send Mail Task for multiple SSIS 2008 packages as opposed to setting up the same Send Mail Task for each individual package? I have 50 or so packages that require the use of send mail functionality. Rather than create the same task over and over again for each package, I'm wondering if I can just create one 'Master' task and pass it a variable containing a given package name. Any help would be appreciated.Stan Benner

Use a SQL secript task at end of each pacakge you need to send mail from then you can use 1.) Call a SSIS package using dtexc, you have to enable command prompt for this, in SQL 2) Create a SP, and call it from the execute SQL task SP can have a code like EXEC sp_send_dbmail @profile_name='<>', @recipients='test@Example.com', @subject='Test message', @body='This is the body of the test message. Congrates Database Mail Received By you Successfully.' Abhinav