Avatar of Amour22015
Amour22015
 asked on

SSIS - Send Mail Task not sending mail

Hi,

I created/migrated a SSIS 2005 Package.
I receive a Success in the Debug window.
Yet I do not receive the email.

Here is a snap shot of the SSIS Package NewMail
NewMail.docx
Microsoft SQL ServerVisual Basic.NETVB Script

Avatar of undefined
Last Comment
Amour22015

8/22/2022 - Mon
EricLynnWright

1.  Right click on one of the email tasks and select "Execute Task"
     (does it work executed by itself?)

2.  Did you set up an SMTP Connection Manager?  (see image)
SMTP Con
Amour22015

ASKER
Hi,

I executed the Mail Task and I received a Success in the Debug window but no email.
I also created a SMTP connection to the Exchange2 Server.  What is really funny is that I have created other SSIS Packages and the Mail Task work fine by me receiving the email.

Please help and thanks
Amour22015

ASKER
Hi,

Just noticed that the SSIS Packages where I do not receive an email have attachments.  So I was hoping that you could help me figure that out.

Thanks....
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
EricLynnWright

So the task not working has an attachment, which is different than the ones that do work?

Assuming so...
I would (1) temporarily take off the attachments.  Then (2) try to right click and just execute the Mail Task by itself.

If that works, then double check your attachment.  Is it there?  

If it doesn't, check your SMTP connection info - is that all correct?  If using Windows Authentication, is that the person you're executing as?
Amour22015

ASKER
Hi,

Well that was a try anyways.  I took out the attachment but still no email coming back.

I hope you can help and thanks
EricLynnWright

Any differences in the SMTP connection in the ones that work and the ones that don't?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Amour22015

ASKER
there is no difference in the SMTP Connections from the ones that work and the ones that don't.  Maybe something up with the Exchange2 Server? and nothing wrong with the SSIS Task?
EricLynnWright

Are you using Windows Authentication?
Amour22015

ASKER
No Windows Authentication

=False
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
EricLynnWright

I don't know how you're running your package- in test mode, under a credential a machine?  You may try to switch to windows authentication and see how that performs.  

Or try you could try a script task and use sp_send_dbmail .

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/1980666d-c36f-44cc-9456-7e132abb12f2/

Not really much to sending an email.  You may need to involve an Exchange administrator.
ASKER CERTIFIED SOLUTION
Amour22015

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Amour22015

ASKER
Great...