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 |
|
kwilliams
194 Posts |
 Posted - 2004-05-04 : 12:39:21
|
| Hello,I've asked this question before, but I kind of hit a brick wall in the development stage. I'm a definite newbie to the use SQL Server DB tables with DTS Packages, but this is my question. I have an existing DB table that contains several of our user's contact information, including email addresses. How do I go about creating an email job within a scheduled DTS package that can email one message to all of these users at one time?I've heard of xp_sendmail, but I don't understand the process fully. When I created a SP named "EXEC xp_sendmail" that contain only my email address, I received a "The Parameters are not set for xp_sendmail". Is there a way to pull all of these email addresses by using a query, and then using the built-in "SQL Mail Task" to send a mass email? One of our policy's changed, and I wanted to inform all of the users at once. Thanks for any & all help in advance.KWilliams |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-04 : 13:14:08
|
| Do you wnt to use dts or would an SP do (it's easier)?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kwilliams
194 Posts |
Posted - 2004-05-04 : 14:10:35
|
| After reviewing it further, I think that a SP would work better for what I'm needing than a DTS package. But I'm totally new to SP's, so I'm not sure how to set it up with an already existing DB table. Is there a simple way to accomplish what I'm needing?KWilliams |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-04 : 14:29:20
|
| Before we get too far down this e-mail thing, has SQL Mail been configured yet?Tara |
|
|
|
kwilliams
194 Posts |
Posted - 2004-05-04 : 14:30:53
|
| No. How do you configure SQL Mail? Is it a simple thing to do? In the meantime, I'll see what I can find about it with Online Books. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-04 : 14:33:00
|
| I posted the link for configuring SQL Mail.Tara |
|
|
|
kwilliams
194 Posts |
Posted - 2004-05-04 : 14:38:46
|
| I'll check it out. Thanks Tara. |
|
|
|
|
|
|
|
|
Using DTS Pkg w/Existing DB Table