Accessing Exchange from SSIS - good strategy?

• Scott-144766

  SSCarpal Tunnel

  Points: 4333

  More actions

  July 24, 2009 at 4:34 am

  #385052

  SQL Server 2005, Exchange 2003 on different servers.

  I've been given the job of writing a process to run on a schedule and count the number of unread email messages in our helpdesk mailbox, then if it's above a certain number send an email to the helpdesk manager. I've tried creating a linked table from Access but it doesn't show me the read/unread status. I've had a look at SSIS but nothing is leaping out at me as a solution. Am I barking up the wrong tree? Any pointers would be gratefully received. I should point out my only requirement is to read from Exchange, not change the mailbox contents in any way - in particular I do not want to change the read/unread status.

  Thanks

  --
  Scott

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 24, 2009 at 9:00 am

  #1029754

  This might help:

  ADO:

  http://msdn.microsoft.com/en-us/library/aa123760(EXCHG.65).aspx

  Other programming tech:

  http://msdn.microsoft.com/en-us/library/ms876253(EXCHG.65).aspx

  CEWII