I have a slight problem with this and I'm really struggling to amend the code to cope with it. I have some really awkward files where the first address1 field...

Thanks Francesc, that works a dream! Good concept to work with in the future. Many thanks.

Here you...

Griffster (8/26/2011)

---

John Mitchell-245523 (8/26/2011)

---

What is the relationship between RecNum and RecInd? I've left out RecInd in the solution below because it looks redundant.

The first thing to do is to...

John Mitchell-245523 (8/26/2011)

---

What is the relationship between RecNum and RecInd? I've left out RecInd in the solution below because it looks redundant.

The first thing to do is to group...

Eurgh...I thought I'd cracked this one but it seems to be inconsistent. The last two times this has run in the daytime the send mail task has run before the...

STOP PRESS...it's working now! May be I hadn't updated the package after all! Thanks for your help.

Mmm... and the...

By running it in BIDS on the server or by running the dtsx?

Koen Verbeeck (8/1/2011)

---

Griffster (8/1/2011)

---

Aside from the print convert statement, this is along the lines of what my package is actually doing. Basically, I have sequence container containing all the tasks...

Koen Verbeeck (8/1/2011)

---

Griffster (8/1/2011)

---

As I run that package for many different purposes. The send mail task would become unworkable. Looks like putting this in works fine in debug mode, but...

No I meant, in my package which runs as one step in the agent job, it sends the email before completion of the embedded execute sql agent job. I.e. my...

Ive incorporated your excellent stored procedure in to my SSIS package to check for completion of the job. Works great when I run it in debug mode. Reverts to asychronous...

As I run that package for many different purposes. The send mail task would become unworkable. Looks like putting this in works fine in debug mode, but it doesn't run...

Thanks for the reply. I found this post recently, which I'm trying to implement as an extra step between my sql agent job and email sends:

http://www.sqlservercentral.com/Forums/Topic1128044-148-1.aspx

What do you...