Mail Profile

SQL 2K
I just developed a DTS and want to add a 'Send Mail Task'.
In 'Send Mail Task' the drop-down for profle name is not displaying the
Profile Name configured under SQL Mail.
I know SQL Mail is confugured under a different account, my question is - As
a developer how can I set this task '
Thanks
MS UserSend Mail Tasks are imperfect, so I never use them. Instead, do an Execute
SQL task that executes xp_sendmail
Robert.
"MS User" wrote:
> SQL 2K
> I just developed a DTS and want to add a 'Send Mail Task'.
> In 'Send Mail Task' the drop-down for profle name is not displaying the
> Profile Name configured under SQL Mail.
> I know SQL Mail is confugured under a different account, my question is - As
> a developer how can I set this task '
>
> Thanks
> MS User
>
>|||In message <F4DBC765-4503-458E-9157-4E24549B516A@.microsoft.com>, Robert
Davis <RobertDavis@.discussions.microsoft.com> writes
>Send Mail Tasks are imperfect, so I never use them. Instead, do an Execute
>SQL task that executes xp_sendmail
>Robert.
>"MS User" wrote:
>> SQL 2K
>> I just developed a DTS and want to add a 'Send Mail Task'.
>> In 'Send Mail Task' the drop-down for profle name is not displaying the
>> Profile Name configured under SQL Mail.
>> I know SQL Mail is confugured under a different account, my question is - As
>> a developer how can I set this task '
>>
>> Thanks
>> MS User
...and one of the reasons why Send Mail is "imperfect", although my term
would be a bit stronger, is that they use MAPI. A MAPI profile is held
as part of the NT user profile, so when developing on your desktop
machine you can only see your personal profile. On the server when you
run it as a scheduled package for example it can only see the profile
for the SQL Server Agent service account, normally what you would use
for SQL Agent Mail.
DTS is client side, and MAPI is profile specific so unless you are
logged onto the server as the service account you created the SQL Mail
profile under this will not be what you suggest. As for the solution, I
second the Exec SQL idea, although I would always use xp_smtp_sendmail
(http://www.sqldev.net). xp_sendmail also uses MAPI is and that is just
asking for trouble in my opinion.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org