February 19, 2009 at 7:28 am
Hi there,
I have a SSIS package that just has a Execute Sql Task which executes a stored procedure. I noticed a Send Email Task but not sure how could I use it. Could I drag the Send Mail Task to that SSIS package and connect Execute Sql Task to it so when the package fails, I could send an email? Is there a nice article that explains how to use this Send Email task?
Thank You.
February 19, 2009 at 7:44 am
I was able to send an email using Send Mail task.
February 19, 2009 at 8:14 am
Hope this may help you.
February 19, 2009 at 10:19 am
All SSIS Tasks have basic instruction on their usage within SQL Server Books Online. Link included below for reference.
http://technet.microsoft.com/en-us/library/ms142165(SQL.90).aspx
Using a Send Mail Task is quite straighforward, you just need to know the connection details of your SMTP server.
Hope this makes sense but let me know if you require further assistance.
Cheers,
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply