For this simplistic example the alternative you suggest would probably work. However, on the job the stored proc probably won't be as simple. At my job we frequently use intermediate...

Yes. The alternative select statement directly from the table would work as well for this example. However, in some circumstances the CAST(NULL AS ...) may be needed. Just remember that...

FWIW: I thought I was having this problem as well. However, it turned out to be a slow mail server. My e-mails from SSIS were sent properly, but I didn't...

I am logging errors to sysdtslog90. Unfortunately, it won't be able to help. Below is the contents of the table containing the error. Notice that there are 3 different executionid's.

In...