SSIS Package does not send email in SQL but does while in VS

[DotNetNewbie]

Hi,

I have a really odd problem. I have modified an old SSIS package I wrote to send email notifications to myself if the job fails etc.

While this works perfectly in Visual Studio it does not work once added into SQL. I get no error message or codes, the job job executes correctly.

It is on a SQL 2005 server with VS 2005.

Any ideas?

Many thanks

.net

 

[DotNetNewbie]

Actually, I am now noticing a failure message in the log:

Login Failed for user 'sa'.[client: <local machine.]

.net