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?

Any help is greatly appreciated.