dbTalk Databases Forums  

DTS and SQL Mail Fails

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


Discuss DTS and SQL Mail Fails in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JR
 
Posts: n/a

Default DTS and SQL Mail Fails - 01-20-2004 , 09:33 AM






When adding Send Mail task to a DTS package, I receive the
following error message:

"Unable to get MAPI profiles"

This is received before the display of the mail
configuration screen. SQL Mail is running and jobs are
sending e-mail messages successfully to defined operators.

I would appreciate any help in solving this problem.

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTS and SQL Mail Fails - 01-20-2004 , 03:21 PM






In message <0a2f01c3df6a$c6115d20$a301280a (AT) phx (DOT) gbl>, JR
<anonymous (AT) discussions (DOT) microsoft.com> writes
Quote:
When adding Send Mail task to a DTS package, I receive the
following error message:

"Unable to get MAPI profiles"

This is received before the display of the mail
configuration screen. SQL Mail is running and jobs are
sending e-mail messages successfully to defined operators.

I would appreciate any help in solving this problem.
Do you have a MAPI profile on the local machine?

SQL Mail requires a MAPI profile for the service account, and the
profile is on the server, but I guess you are building packages on a
workstation machine. Your user on that local machine needs a MAPI client
and profile.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
  #3  
Old   
 
Posts: n/a

Default Re: DTS and SQL Mail Fails - 01-20-2004 , 03:58 PM



The server has a profile for the service account. The
service account is a member of the local admins. The user
also has a profile define on the local workstation.

Quote:
-----Original Message-----
In message <0a2f01c3df6a$c6115d20$a301280a (AT) phx (DOT) gbl>, JR
anonymous (AT) discussions (DOT) microsoft.com> writes
When adding Send Mail task to a DTS package, I receive
the
following error message:

"Unable to get MAPI profiles"

This is received before the display of the mail
configuration screen. SQL Mail is running and jobs are
sending e-mail messages successfully to defined
operators.

I would appreciate any help in solving this problem.

Do you have a MAPI profile on the local machine?

SQL Mail requires a MAPI profile for the service account,
and the
profile is on the server, but I guess you are building
packages on a
workstation machine. Your user on that local machine
needs a MAPI client
and profile.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server
professionals
http://www.sqlpass.org

.


Reply With Quote
Reply




Thread Tools
Display Modes

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.