[264] An attempt was made to send an email when no email session has been established

Hi

I have go an integration service package which sends email on completion of the package. It is not a notification email. The email is being sent from the integartion service package.

The package is being scheduled using SQL Agent Job scheduler. It has few steps each and every step sends a mail on completion and then it moves to the next step. If i run each step seperately. It completes the job and fails when sending the email.

Giving the error

[264] An attempt was made to send an email when no email session has been established.

The wierd part is that sometime it sends but some times it does give me this error.

Any help in this regard is very much appreciated.

Thanks

Mani

Please refer the below link. This should help

http://blogs.msdn.com/gopsdwarak/archive/2006/04/25/583434.aspx