I have stumbled on a workaround.

The SSIS is not returning a status to vbscript when an Import tasks is involved, however it is keeping the objExec.stdOut locked until the package...

MentalWhiteNoise (7/8/2008)

---

Just and FYI, you can send mail from SSIS.

1) Use an Execute SQL Task to pull the variabels

2) Create a Send Mail Task; set Expressions to map the variables...

Actually this is exactly what I have done. I had a look at sp_send_dbmail but I couldn't see how you set the "from" value. This mechanism will be used by...

Hi Michael. Thanks again for your help - it is much appreciated!

When I use dtexec, with exactly the same argument, to run the SSIS from the command prompt it completes...

Hi Michael - thanks for your reponse. If I could trouble you a bit more...

There is nothing in the BlkBy column.

However I am confused by what I am seeing...

Why am I not using sp_send_dbmail? Mosty because I'd never heard of it 😉

Thanks for the tip!

Carol