Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2007-09-06 : 18:15:36
|
| First I created a mail profile by double clicking the Mail icon from Control Panel. Then I dropped the Send Mail Task on the DTS Package, but I got a DTS Designer Error "Unable to get MAPI profiles." I clicked the OK button and got a Package Error "Error Source: Microsoft Data Transformation (DTS) Package Error Description: MAPI returned an error." I clicked the OK button. The Send Mail Task Properties pop up. There is no selection at the Profile name dropdown. Can someone step me through how to use the Send Mail Task to send email if the DTS Package fails?Thanks.DanYeung |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-06 : 23:15:18
|
| Which windows account did you create mail profile for? Try logon server with sql service account and create mail profile for it. |
 |
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-09-07 : 10:06:52
|
| sounds like you havent created your sql mail account (support services - sql mail). If you have set it up test it through there first before adding it onto a DTS. If there is an account but it doesnt work try running "exec xp_stopmail go exec xp_startmail" in QA, this will clear any problems with a frozen session. |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2007-09-07 : 11:30:36
|
| How do I create a sql mail account? Thanks.DanYeung |
|
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-09-07 : 12:00:35
|
quote:
Originally posted by danyeung
How do I create a sql mail account? Thanks.DanYeung
Log in as the user your sql service logs in as. open outlook and make sure the mail profile is setup, if not set it up and make sure you can send a mail through outlook.Once this is complete go into EM - support services - SQL mail and you should see "outlook" in the drop down list. if not restart your service when you can and try again. Once the mail profile is setup you can use xp_sendmail. |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2007-09-07 : 13:03:05
|
| Sorry, I forgot to mention that we want to use SMTP Mail Server instead of Outlook. How do I create a sql mail account for SMTP server and how to setup a profile? After the account is created and the profile is setup, how do I define in the Send Email Task in DTS that send email only when the DTS fails.Thanks.DanYeung |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-08 : 00:14:48
|
| Sql agent doesn't support smtp mail. |
|
|
|
|
|
|
About the Send Mail Task