BIDS Send Mail Task - 'Failure Sending Mail'

[Skittle]

I am just starting to use BIDS. I want to be able to send an email from the Send Mail Task.

I have set up a simple package with an SMTP connection and referenced the connection in a Send Mail Task.

My 'Send Mail Task' fails with the error, 'Failure Sending Mail'. I think the problem relates to my SMTP connection definition. I have IIS installed with a Default SMTP Virtual Server but I don't have a clue what to check.

The Default SMTP Virtual Server looks OK.

I can send an email via vbscript from the same machine although I don't know if vbscript uses IIS in the same way:-

Set objMessage = CreateObject("CDO.Message") 
objMessage.Subject = "Example CDO Message" 
objMessage.From = "MyEmail@MyCompany.com" 
objMessage.To = "MyEmail@MyCompany.com" 
objMessage.TextBody = "This is a test." 
objMessage.Send

Dazed and confused

 

[mrdenny]

What settings have you setup in the SMTP connection defination?

Why not use sp_send_dbmail instead?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Skittle]

Hi dude,

yuop I could use sp_send_dbmail but I'd like to be able to use the Send Mail Task simply because....Its There!!

I think what I am missing is the ability to authenticate to the SMTP server. I can't spot the property or location where I specify a username and password. I guess its the
ConnectionString property.


Dazed and confused

 

[Skittle]

After days of pain....it turns out a hidden option in a new virus program on my machine blocks scripted email transmission.....

I disabled that particular feature and now it works.

(Skittle sobs quietly in the corner.....)

Dazed and confused