I have Exchange 2003 and SQL 2000 on one box. I would like to combine several public calendars to create a more detailed "company calendar" for board members.
I'd like to connect Exchange and SQL with a DTS package to do these transformations. Obviously this connection isn't as simple as with Access. The prob here is I don't know VB or ADO, which may be necessary to do this. If so, just give me some pointers and I'll research what I need.
So, any help on how to make SQL Server connect to Exchange as cleanly as Access can, so a DTS package can transform Exchange data?