Send Mail Task Issue

Question

Post reply

Send Mail Task Issue

Leland Walker

SSC Journeyman

Points: 85
More actions
March 30, 2009 at 10:53 am

#132312

I have a SSIS package that has a Send Mail Task control. When I run the package from Visual Studio the email sends with no problem, but the package fails when I initiate or schedule it from the SQL Server Agent.
I need help solving this issue.
Thanks

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

vishal.gamji SSCertifiable Points: 6126 More actions · Answer 1

Does your SMTP connection have any (SSIS) configurations?

Leland Walker SSC Journeyman Points: 85 More actions · Answer 2

no...I am not using any configurations. should I?

Thanks

vishal.gamji SSCertifiable Points: 6126 More actions · Answer 3

vishal.gamji

SSCertifiable

Points: 6126

March 30, 2009 at 4:53 pm

#968786

can u post your smtp connection string?

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

Leland Walker (3/30/2009)
I have a SSIS package that has a Send Mail Task control. When I run the package from Visual Studio the email sends with no problem, but the package fails when I initiate or schedule it from the SQL Server Agent.
I need help solving this issue.
Thanks

Can you post what is the error when you execute from SQL Server Agent? Do you use proxy account in SQL Server Agent or you use the default execution account? Most probably the account (which is usually the local system account) doesn't have permissions to access your SMTP server.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Naveen.Jain-839238 Valued Member Points: 51 More actions · Answer 5

I guess it has nothing to do with any configurations, When you are running in IDE you use your login credintials, but when you schedule you use Sql service account. you need to look onto this.

go to services(My Computer (right click) > Manage > services and applications (tab) > services) and see on what account this sql server agent is running and the permission it has.

cheers,

Naveen

Leland Walker SSC Journeyman Points: 85 More actions · Answer 6

I checked a few things out on my end and it appears that the SQL Server Agent can not initiate or run scheduled jobs from the Standard Edition of SQL Server 2005.

I hope there is a work around.

Thanks for the responses.

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

Leland Walker (4/2/2009)
I checked a few things out on my end and it appears that the SQL Server Agent can not initiate or run scheduled jobs from the Standard Edition of SQL Server 2005.
I hope there is a work around.
Thanks for the responses.

What do you mean by "cannot initiate or run" ? Is the default service account the problem? If that is the case you have to setup and use a proxy account for your package execution.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

A Little Help Please SSCarpal Tunnel Points: 4764 More actions · Answer 8

As far as i know you can't edit the following, so your going to have to Import the package again, this time, under the:

Protection Level select 'Rely on server storage and roles for access control'

then you will need to edit the job to point that this pakage....

Leland Walker SSC Journeyman Points: 85 More actions · Answer 9

What I meant was when I try to start the job, by click on Start Job from the SQL Server Agent, it fails....If I schedule the job to run it fails as well.

This is the error message I'm getting.

The task "Send Mail Task" cannot run on this edition of Integration Services.

COZYROC One Orange Chip Points: 28499 More actions · Answer 10

Leland Walker (4/2/2009)
What I meant was when I try to start the job, by click on Start Job from the SQL Server Agent, it fails....If I schedule the job to run it fails as well.
This is the error message I'm getting.
The task "Send Mail Task" cannot run on this edition of Integration Services.

What edition of SQL Server do you have in use? Btw you can send emails using scripts. Check here for ideas.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Leland Walker SSC Journeyman Points: 85 More actions · Answer 11

I'm using SQL SERVER 2005 - Standard Edition.

I tried using scripts to send the e-mail and the job failed that way as well.

Thanks for the help.

COZYROC One Orange Chip Points: 28499 More actions · Answer 12

Leland Walker (4/2/2009)
I'm using SQL SERVER 2005 - Standard Edition.
I tried using scripts to send the e-mail and the job failed that way as well.
Thanks for the help.

I'm not able to find a Microsoft sheet listing what each edition of SQL Server contains, but I think your SQL Server installation is corrupted. You should have Send Mail Task and Script Task available in the Standard Edition. You may have to reinstall your SQL Server + Integration Services.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/