September 14, 2004 at 8:00 am
Has anyone ever used SQL server to send outlook meeting requests? Any suggestions as to where i research on the matter?
Thanx
Russ
September 14, 2004 at 10:19 am
Although I havn't done this I do run an executable each night that check's for data integrity issues between an SQL table and an Exchange Server using Web DAV. Unfortunately another programmer did all the heavy lifting and I simply modified one of his files to perform the data check, meaning I can't provide a lot of help on the how to set up Web DAV.
My understanding is that Yukon will allow us to build the script directly into a DTS, until then we're stuck with the SQL Server running the executable.
Everett Wilson
ewilson10@yahoo.com
September 14, 2004 at 10:49 pm
This may or may not be what you're looking for, but I send emails with "vCalendar" attachments. I haven't played with SQL email in a while to remember if it supports attachments or not; might be a way to do it in DTS with script and CDONTS and you could use this code, or wait for Yukon and do it with the Framework (lol):
This is a text file with a .vcs extension and contents like this (I do all this in vbscript now; easy to modify to T-SQL). Most of the vars are self-explaining, although I was using this to set up an online meeting so put "URL" in the LOCATION space; you can put an address, meeting room, or whatever:
dim strTmp
strTmp = "BEGIN:VCALENDAR" & vbCrLf
strTmp = strTmp & "VERSION:1.0" & vbCrLf
strTmp = strTmp & "BEGIN:VEVENT" & vbCrLf
strTmp = strTmp & "SUMMARY;ENCODING=QUOTED-PRINTABLE:" & Subject & vbCrLf
strTmp = strTmp & "DESCRIPTION;ENCODING=QUOTED-PRINTABLE:" & Replace(Contents,vbCrLf,"=0D=0A") & vbCrLf
strTmp = strTmp & "LOCATION;ENCODING=QUOTED-PRINTABLE:" & URL & vbCrLf
strTmp = strTmp & "DTSTART:" & ReturnZulu(StartDate) & vbCrLf
strTmp = strTmp & "DTEND:" & ReturnZulu(EndDate) & vbCrLf
strTmp = strTmp & "END:VEVENT" & vbCrLf
strTmp = strTmp & "END:VCALENDAR" & vbCrLf & " " & vbCrLf & vbCrLf
GetVCal=strTmp
"ReturnZulu" above returns a format like "20031016T173000Z". I'm calling some JScript functions from vbscript to accomplish this (there's probably an easier way but I threw this together in a hurry; it was a simple project and didn't deserve lots of research). This was probably the trickiest part for me, getting this date string formatted correctly:
dim thedate
thedate=strDate
theyear=DateToUTCFullYear(thedate)
themonth=right("0" & DateToUTCMonth(thedate),2)
theday=right("0" & DateToUTCDate(thedate),2)
thehour=right("0" & DateToUTCHours(thedate),2)
theminute=right("0" & DateToUTCMinutes(thedate),2)
ReturnZulu=theyear & themonth & theday & "T" & thehour & theminute & "00Z"
Hope that helps some. Google "vCalendar" for more info.
Thanks,
Brett Hacker
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply