July 22, 2009 at 5:06 am
How do i go about in modifying my SSIS package so it sends and email to me, either if the package Fails or Successeds.
The following steps are taken in my package.
1. TRUNCATE TABLE sql table
2. Append data from MS Access to SQL Server table
I would like to have an email to be sent to me, how can this be done?
Thanks in advance
July 22, 2009 at 2:38 pm
Have u had a chance to look at the Email Task ?? It is really simple. Connect your work items to the email task with a workflow condition and based on condition send email.
July 23, 2009 at 8:12 am
Perfect, many thanks for the advice
vishal.gamji (7/22/2009)
Have u had a chance to look at the Email Task ?? It is really simple. Connect your work items to the email task with a workflow condition and based on condition send email.
July 23, 2009 at 8:36 am
can't seem to get my package to run correctly it fails on the email option...
below is the error message i am getting...
Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Failure sending mail.".
Task failed: Send Mail Task
Warning: 0x80019002 at Package Test: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package Test.dtsx" finished: Failure.
The program '[2820] Package Test.dtsx: DTS' has exited with code 0 (0x0).
any ideas?
July 23, 2009 at 2:53 pm
Hope I'm not asking the obvious here, but did you setup a connection manager (of type SMTP) to connect to your outgoing mail server? If so, what kind of environment are you in? In my environment, I'm using our corporate outgoing mail server so all I had to do was create an SMTP connection manager and drop in the mail-server's name....something like, "OUREXCH01.domain.com" in my case (pulled it from my Outlook account settings)...and viola, it worked.
July 24, 2009 at 3:44 am
I have created a SMTP connection manager
I am using work server and located the Server name from Outlook.... which is "ATE"
but it still doesn't work...
can you help?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply