"Darren Green" wrote:

> Ok, so there is a profile available, but the task thinks there isn't Can
> you confirm the profile is still there by looking in Mail in Control
> Panel, then Show Profiles. Also open EM and go to SQL Mail, do you get
> the profile listed in the drop-down? If it is there, then I have no
> idea. Some bug or maybe permissions related, but doesn't make too much
> sense if the profile is available for SQL Mail as well.
>
> I still stick by my previous recommendation, regardless of the cause.
>
> In message <808B98AE-B156-45F6-B3AE-6BA2C235E667@microsoft.com>, Steve
> Skidmore <SteveSkidmore@discussions.microsoft.com> writes
> >I should have mentioned that. I am logged into the server as the service
> >account and the profile was created for the service account and has been
> >working when used with SQL mail.
> >
> >"Darren Green" wrote:
> >
> >> Remember DTS I a client side tool, so unless you are logged onto the server
> >> console, with the service account you cannot see the profile you expect.
> >> Because of this and my hatred for MAPI in server environments I suggest you
> >> don't bother with this task and try one of these-
> >>
> >> SMTP Mail Task
> >> (http://www.sqldev.net/dts/SMTPTask.htm)
> >>
> >>
> >> XPSMTP
> >> (http://www.sqldev.net/xp/xpsmtp.htm)
> >>
> >>
> >> "Steve Skidmore" <SteveSkidmore@discussions.microsoft.com> wrote in message
> >> news:0EEB4067-1CB7-4FF2-A5DD-4AD3C29B4E49@microsoft.com...
> >> > Hello All,
> >> >
> >> > I am trying to use a send mail task in a DTS job, when I add the task to
> >> the
> >> > designer the following error dialog appears:
> >> >
> >> > Title = DTS Designer Error
> >> > Msg = Unable to get MAPI profiles.
> >> >
> >> > If I click Ok the dialog goes away and the send mail properties are
> >> > displayed but the profiles list is empty. I do have a profile configured
> >> and
> >> > am successfully using it for SQLMail and to send mail via the
> >> SQLServerAgent.
> >> >
> >> > As always any help is appreciated,
> >> >
> >> > Steve Skidmore
> >>
> >>
> >>
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>