One Send Mail Task for multiple packages?
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
May 14th, 2012 12:45am
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
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 1:10am