How can I create a DTS Package to export data to an .ics
file in this layout? With the Cap names being the fields.
BEGIN:VCALENDAR
METHOD:PUBLISH
BEGIN:VEVENT
ORGANIZER:MAILTO:vJones (AT) philamuseum (DOT) org
DTSTART:20040805T190000Z
DTEND:20040805T203000Z
LOCATION:Pereleman
TRANSP:OPAQUE
SEQUENCE:0
DTSTAMP:20040803T023418Z
SUMMARY:Access: Training
PRIORITY:5
CLASS:PUBLIC

In article <2b7a501c4684e$958c8a90$a401280a (AT) phx (DOT) gbl>, Vincent Jones
wrote:
How is the actual data stored in the first place? If it is stored in a
table then you could build the output like this

SELECT 'BEGIN:' + colX + CHAR(13) + CHAR(10) + 'METHOD:' + colX1......
FROM TABLE


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs