dbTalk Databases Forums  

SQL Server Email's

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Server Email's in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Himanshu Kaushal
 
Posts: n/a

Default SQL Server Email's - 05-02-2005 , 02:12 PM






Hi,

I want send a formated mail ,every one hour to our client's I want to
use SQL Server ,is their any way do it.



*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
Ray5531
 
Posts: n/a

Default Re: SQL Server Email's - 05-02-2005 , 03:52 PM






You got to use an schaduled job by using this Extended store proc:
http://www.sqldev.net/xp/xpsmtp.htm

HTH
Ray

"Himanshu Kaushal" <ogs_himanshu (AT) yahoo (DOT) com> wrote

Quote:
Hi,

I want send a formated mail ,every one hour to our client's I want to
use SQL Server ,is their any way do it.



*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
  #3  
Old   
Ray5531
 
Posts: n/a

Default Re: SQL Server Email's - 05-02-2005 , 03:57 PM



Sorry I meant:
You got to use an schaduled job **AND** using this Extended store proc:
http://www.sqldev.net/xp/xpsmtp.htm


"Ray5531" <RayAll (AT) microsft (DOT) com> wrote

Quote:
You got to use an schaduled job by using this Extended store proc:
http://www.sqldev.net/xp/xpsmtp.htm

HTH
Ray

"Himanshu Kaushal" <ogs_himanshu (AT) yahoo (DOT) com> wrote in message
news:eJV5Vr0TFHA.2056 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

I want send a formated mail ,every one hour to our client's I want to
use SQL Server ,is their any way do it.



*** Sent via Developersdex http://www.developersdex.com ***





Reply With Quote
  #4  
Old   
Yunus's Group
 
Posts: n/a

Default Re: SQL Server Email's - 05-03-2005 , 09:01 AM



Himanshu,

If the process of sending email is part of DTS package, then you can
add another ActiveX script task and use CDONT object to send email.

Here is the sample,

Dim objMessage
Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = strSubject
objMessage.Sender = strFrom
objMessage.From = strFrom
objMessage.To = strTo
objMessage.TextBody = strBody
objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing")
= 2
objMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")
= strMailServerName
objMessage.Configuration.Fields.Update
objMessage.Send

Yunus.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.