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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Sending Email through DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-27 : 08:51:18
Yugant writes "Hello
can we send the news letters to n no. of users using DTS services if so how is it possible"

msrviking
Starting Member

7 Posts

Posted - 2001-11-28 : 03:25:23
Hi,

Firstly like to stress that DTS is an Import / Export facility given by Sql Server. For sending mails u needn't use DTS. There are several other ways to do it.

Go to Top of Page

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2001-11-28 : 07:15:40
search here for "mail"....it'll give you a lead on how to deal with this issue.

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-11-28 : 08:00:45
I actually use DTS to send mail with the Mail Queue method (Look for the article). The VBS parser in scheduled jobs seems to be a bit screwy so I use a DTS script task. That works well.

To just do a standalone email, use a DTS script task and use VBS.



Damian
Go to Top of Page
   

- Advertisement -