dbTalk Databases Forums  

Sending Email using ActiveX Script task

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Sending Email using ActiveX Script task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Sending Email using ActiveX Script task in the microsoft.public.sqlserver.dts forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM





On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #12  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM





On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #13  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM


On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #14  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM


On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #15  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM


On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #16  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM


On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
  #17  
Old   
matteus
 
Posts: n/a

Default Re: Sending Email using ActiveX Script task - 07-16-2008 , 04:10 AM


On Jul 15, 7:29 am, Bhuvaneswari Ramamurthi
<BhuvaneswariRamamur... (AT) discussions (DOT) microsoft.com> wrote:
Quote:
In my SQL Server 2000 DTS package i need to send e-mails to the list of
recipient. I am using xp_smtp_sendmail stored procedure.

When i send email to unavailable recipient i need to bounce back the e-mail
to the sender. But when i use the stored procedure the mail was not bounce
back.

Is it possible to bounce back the e-mail if the recipient is unavailable.

Pls give me a suggestion for this issue.
--
Regards,
Bhuvana
Could also be that your executing stproc with a security context to
which no mail account exists?
I mean, if your executing this stproc from sa... or from any sql
server login i believe that it would never work.
If so try executing with your windows account, log in to... let's say
Query analyzer and try.

Whatever the cause... Ed's script and suggestions could make your day
Bye
M.


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top