Send Email Task - not able to send mails

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Send Email Task - not able to send mails

Author

Topic

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-01-14 : 08:06:51

Hi

I am building a small package in SSIS which has only send email task component.

In SQL 2K we use to select default outlook profile.

In SSIS its asking for SMTP connection.
I have put my outlook server as SMTP server in the connection wizard.

But its fails.

How do I send mails using SSIS.
Do I need to configure any thing?

Please reply

Regards,
Sachin

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-14 : 08:25:47

did you check books online?
http://msdn.microsoft.com/en-us/library/ms142165.aspx

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-01-14 : 08:39:19

I did checked on books online.

What is this SMTP connection.

In DTS it use to take default outlook profile.

Here its giving me an error is SSIS with just red color.

Rrgards,
Sachhin

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-14 : 08:49:22

quote:
Originally posted by sachingovekar

I did checked on books online.

What is this SMTP connection.

In DTS it use to take default outlook profile.

Here its giving me an error is SSIS with just red color.

Rrgards,
Sachhin

go to progress tab and see whats the error message

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-01-15 : 01:43:56

It says SMTP server is required.

How will i get the server name. I am using Outlook.

In DTS we were just selecting outlook default profile.

Nagaraj
Starting Member

14 Posts

Posted - 2009-01-15 : 03:49:27

Hi,

Try to give the ipaddress of the mail server in SMTP connection

Nagaraj.

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-01-21 : 05:29:43