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 |
|
Tyecom
Starting Member
12 Posts |
 Posted - 2007-11-14 : 18:35:23
|
| I'm trying to create a SSIS package that will send me a email when the package runs successfully and when it fails. My entire package runs successfully until it get to the Send Mail Task, where it always fails. Do I have to configure something on the database end or what? Thank you in advance.Using SQL Server 2005Using sample database AdventureWorks |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 10:23:01
|
| Are you talking about running it from your dev machine or at the sql server where it was deployed? |
 |
|
|
Tyecom
Starting Member
12 Posts |
Posted - 2007-11-15 : 10:57:01
|
| From the dev machine. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 13:08:28
|
| If you have a seperate dev app that is smtp enable, you could verify if the whole smtp settings on your machine is working. Things to check in this area includes smtp connection to the server (i.e. IP, SSL, authentication, etc.)If everything works, then try to run a send mail task alone in a ssis.Anyway, there is nothing in the database server for you to config at this environment. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-11-15 : 14:25:12
|
| What's the error message you're getting? You can see that under the "Progress" view. |
|
|
|
|
|
|
Problem Sending E-Mail Notification Using SSIS