Don't send the email from the event handler.

Add an email task that runs at the end of the processing and use what I recommended earlier.

Jeff Moden (8/4/2014)

---

Alvin Ramard (8/4/2014)

---

GilaMonster (8/4/2014)

---

If the questions have worn you out, may I suggest a couple of maths limericks?

http://iwastesomuchtime.com/on/?i=93785

A dozen, a gross and a score

plus three time the square...

GilaMonster (8/4/2014)

---

If the questions have worn you out, may I suggest a couple of maths limericks?

http://iwastesomuchtime.com/on/?i=93785

A dozen, a gross and a score

plus three time the square root of four

divided by...

Create a variable to hold the text you want as the email body.

Have the event handler(s) append the error messages to this variable.

Add an email task at the...

SCARY!!!!!!

Grant Fritchey (7/31/2014)

---

Sarah Wagner (7/31/2014)

---

I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all...

Luis Cazares (7/30/2014)

---

Eirikur Eiriksson (7/30/2014)

---

Guess shrinked is the simple mode...

WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:

Tim Mitchell (7/29/2014)

---

A foreach loop in SSIS is, by definition, an iteration of n items, in which n is defined at the beginning of the loop. So you can't...

vito.mangogna (7/29/2014)

---

I'm trying to write a query that will return three related values from a single value.

My input data in it's simplest form is this:

select employeeID, TotalHours from TimeTicket

I...

If you're looking for a list of names, Google: "nicknames and full names" and you'll find a few.

What you're trying to do is a simple use of a lookup table....

Jeff Moden (7/24/2014)

---

Alvin Ramard (7/24/2014)

---

Jeff Moden (7/23/2014)

---

halifaxdal (7/23/2014)

---

Alvin Ramard (7/23/2014)

---

Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the...

Jeff Moden (7/23/2014)

---

halifaxdal (7/23/2014)

---

Alvin Ramard (7/23/2014)

---

Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or...

It looks like a normal task, but you task was made more complicate by the fact that the file is not properly formatted for a "data exchange" file. Sometimes,...

Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or C#, or at least fix...