error in xp_sendmail

Hi All,
I am using SQL SERVER 2005 Standard Edition. I have enabled
database mail from Surface Area Configuration and also configured
database mail from Object Explorer ->management.
When i am trying to send mail by using extended stored
procedure xp_sendmail i am getting error as follows:
xp_sendmail: Procedure expects parameter @.user, which was not
supplied.
It will be a great help if you guys can help me.
Thanks in advance.
Hi,
It looks like you configured Database Mail, a new feature in SQL Server
2005, but are trying to send e-mail using xp_sendmail, a stored procedure
that uses SQL Mail, which is a different SQL Server feature. Use
sp_send_dbmail instead. Look BOL for more details and examples.
Make sure you really configured Database Mail, right-click Database Mail and
select 'Send Test E-mail' to test that it works.
By the way, SQL Mail, according to BOL, will be removed in a future version
of SQL Server.
Hope this helps,
Ben Nevarez
"mohit" wrote:

> Hi All,
> I am using SQL SERVER 2005 Standard Edition. I have enabled
> database mail from Surface Area Configuration and also configured
> database mail from Object Explorer ->management.
> When i am trying to send mail by using extended stored
> procedure xp_sendmail i am getting error as follows:
> xp_sendmail: Procedure expects parameter @.user, which was not
> supplied.
> It will be a great help if you guys can help me.
> Thanks in advance.
>

error in xp_sendmail

Hi All,
I am using SQL SERVER 2005 Standard Edition. I have enabled
database mail from Surface Area Configuration and also configured
database mail from Object Explorer ->management.
When i am trying to send mail by using extended stored
procedure xp_sendmail i am getting error as follows:
xp_sendmail: Procedure expects parameter @.user, which was not
supplied.
It will be a great help if you guys can help me.
Thanks in advance.Hi,
It looks like you configured Database Mail, a new feature in SQL Server
2005, but are trying to send e-mail using xp_sendmail, a stored procedure
that uses SQL Mail, which is a different SQL Server feature. Use
sp_send_dbmail instead. Look BOL for more details and examples.
Make sure you really configured Database Mail, right-click Database Mail and
select 'Send Test E-mail' to test that it works.
By the way, SQL Mail, according to BOL, will be removed in a future version
of SQL Server.
Hope this helps,
Ben Nevarez
"mohit" wrote:
> Hi All,
> I am using SQL SERVER 2005 Standard Edition. I have enabled
> database mail from Surface Area Configuration and also configured
> database mail from Object Explorer ->management.
> When i am trying to send mail by using extended stored
> procedure xp_sendmail i am getting error as follows:
> xp_sendmail: Procedure expects parameter @.user, which was not
> supplied.
> It will be a great help if you guys can help me.
> Thanks in advance.
>|||On Jan 18, 12:51=A0pm, Ben Nevarez
<BenNeva...@.discussions.microsoft.com> wrote:
> Hi,
> It looks like you configured Database Mail, a new feature in SQL Server
> 2005, but are trying to send e-mail using xp_sendmail, a stored procedure
> that uses SQL Mail, which is a different SQL Server feature. Use
> sp_send_dbmail instead. Look BOL for more details and examples.
> Make sure you really configured Database Mail, right-click Database Mail a=nd
> select 'Send Test E-mail' to test that it works.
> By the way, SQL Mail, according to BOL, will be removed in a future versio=n
> of SQL Server.
> Hope this helps,
> Ben Nevarez
>
> "mohit" wrote:
> > Hi All,
> > =A0 =A0 =A0 =A0I am using SQL SERVER 2005 Standard Edition. I have enabl=ed
> > database mail from Surface Area Configuration and also configured
> > database mail from Object Explorer ->management.
> > =A0 =A0 =A0 =A0When i am trying to send mail by using extended stored
> > procedure xp_sendmail i am getting error as follows:
> > =A0 =A0 xp_sendmail: Procedure expects parameter @.user, which was not
> > supplied.
> > =A0 =A0 =A0It will be a great help if you guys can help me.
> > =A0 =A0 =A0Thanks in advance.- Hide quoted text -
> - Show quoted text -
Hi,
Thanks a lot. It helped me a lot.

Error in send mail task

I have a script task in which I check the size of a file.

If the size of a file is greater then 0 KB then I need to send this file as an attachment using send email task.

If size is equal to 0 KB then I don't want to send email at all.

In the script task, I have a flag(@.sFileExists) which i set to true in case of size of file greater then 0 and false in other case.

I am using a precedance constraint (Expression : @.sFileExists=true) and condition is logical AND.

After script task based on the condition (@.sFileExists=true) I am using the send email task for sending the email.

But I am not receiving the email. Please sugest where I am wrong.

Please note that the send email task is working all-right separately.

Do you get any error?
Does the task gets executed at all (when debugging in BIDS - does it turn green)?