How to get calender data from OutLook Server for all users

Question

Hi All,

Currently I have requirement which has something like:

Create a package which connects to outlook Server, get the Calender details for all user who are connected to that server, then import the complete data for all users to SQL Server table.

Can any one help me this out...

---

Regards, Kishlay Anand

Answer 1

I think there is an Exchange webservice that you can call in a Script Component.
http://msdn.microsoft.com/en-us/library/dd633710%28EXCHG.80%29.aspx

http://msdn.microsoft.com/en-us/library/bb409286(v=exchg.140).aspx

An other option could be to try something with the Microsoft.Office.Interop.Outlook dll, but that will require an office installation which is not very common/recommended on a server.

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.aspx

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Hi Joost,

It would be great if you give some demo and workflow to achieve this requirement. I wnet to all the links you provided in the post but how to use those webservices and xml.

Please Help me out.

---

Regards, Kishlay Anand

Answer 3

Hi Joost,

It would be great if you give some demo and workflow to achieve this requirement. I wnet to all the links you provided in the post but how to use those webservices and xml.

Please Help me out.

---

Regards, Kishlay Anand

If you go to the first link, there are tons of MSDN articles on how to use the EWS API.
Here's one of them: http://msdn.microsoft.com/en-us/library/dd633626(v=exchg.80).aspx

I doubt that you have read them all. Most of them have C# examples, so you should have everything to get you started.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

Hi Joost,

It would be great if you give some demo and workflow to achieve this requirement. I wnet to all the links you provided in the post but how to use those webservices and xml.

Please Help me out.

---

Regards, Kishlay Anand

This is a useful article about how to connect to a webservice in a script component:
http://blogs.msdn.com/b/dbrowne/archive/2010/07/08/how-to-configure-an-ssis-package-to-access-a-web-service-using-wcf.aspx

And here is a msdn Exchange forum where they probably now more about that webservice interface:
http://social.technet.microsoft.com/Forums/en/exchange2010/threads

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 5

Hi Koen,

I do not know how to use this code..Which component I should use in SSIS so that I can connect to Microsoft outlook and get the users calender details and then load into SQL server (Destination).

Help me out with component.

---

Regards, Kishlay Anand

Answer 6

I do not know how to use this code..Which component I should use in SSIS so that I can connect to Microsoft outlook and get the users calender details and then load into SQL server (Destination)

You use either a script task (in the control flow) or a script component (in the dataflow).

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 7

Hi Joost,

Can you name webservices that are exposed so that I can connect to Exchange server.

---

Regards, Kishlay Anand

Answer 8

Hi Joost,

Can you name webservices that are exposed so that I can connect to Exchange server.

---

Regards, Kishlay Anand

No! Please go to the Exchange forum for exchange related questions.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter