Change "From" in Notifications

#1

I need to change the "From" field in the DTS package notification so users
can reply to the e-mail and have it directed to another e-mail account that's
not the default profile . We only have one profile on all the servers and
I'd prefer to keep it that way if at all possible and using xp_sendmail.

Is there a way to change the "From" field e-mail address on a DTS package
notification without having to "spoof" it or create another profile?

Thanks for your help.

Colette Klier, Klier Image

#2

Colette wrote:

Quote:

I need to change the "From" field in the DTS package notification so users
can reply to the e-mail and have it directed to another e-mail account that's
not the default profile . We only have one profile on all the servers and
I'd prefer to keep it that way if at all possible and using xp_sendmail.

Is there a way to change the "From" field e-mail address on a DTS package
notification without having to "spoof" it or create another profile?

Thanks for your help.

Colette Klier, Klier Image

The is no way to change this, so another profile it is.

Or

Move away from the restrictions of profiles entirely. See
http://www.sqldev.net for a XP and DTS Task, both of which are much more
flexible I find, and use SMTP directly. You can change any parameters
you like.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

#3

Ah, excellent!

Thanks for your help!

Colette

"Darren Green" wrote:

Quote:

Colette wrote:
I need to change the "From" field in the DTS package notification so users
can reply to the e-mail and have it directed to another e-mail account that's
not the default profile . We only have one profile on all the servers and
I'd prefer to keep it that way if at all possible and using xp_sendmail.

Is there a way to change the "From" field e-mail address on a DTS package
notification without having to "spoof" it or create another profile?

Thanks for your help.

Colette Klier, Klier Image

The is no way to change this, so another profile it is.

Or

Move away from the restrictions of profiles entirely. See
http://www.sqldev.net for a XP and DTS Task, both of which are much more
flexible I find, and use SMTP directly. You can change any parameters
you like.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Change "From" in Notifications

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

Change "From" in Notifications - 09-01-2005 , 08:06 AM

Re: Change "From" in Notifications - 09-05-2005 , 01:41 AM

Re: Change "From" in Notifications - 09-05-2005 , 09:37 AM