How can I read an Email (outlook 2003) using SSIS package on SQLSERVER 2005

I need to access a specific E-Mail folder from an SSIS package created on a SQLServer 2005.
The server does not have Outlook installed (this is a company decision).

I need to read the emails and extract data to input into a SQL dB.  Inputing the data into a dB is no problem just the access to and reading of the emails.

RabEDFAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes, you can do it provided you have created those CLR functions in SQL Server and use TSQL statements within your SSIS package by reading from Exchange Server directly instead of Outlook.
Hope that is what you require..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can read emails from Exchange Server into SQL Server via the scripts provided here:

http://msdn.microsoft.com/en-us/library/bb508823%28EXCHG.80%29.aspx

Do Note that it is not recommended to use these scripts in Production Environment..
0
 
GundogTrainerCommented:
You mention Outlook 2003 - can you confirm what version of Exchange you are using? 2003,2007 or 2010.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
And missed mentioning one more thing..

* SQL Server can send emails which can be read in Outlook but SQL Server can't receive or read emails from Outlook.
* Above approach mentioned in my link suggests a way to read emails directly from Exchange Server and not from Outlook.
0
 
RabEDFAuthor Commented:
We are using Exchange 2003
0
 
RabEDFAuthor Commented:
rrjegan17: - i really need to be able to read a mail from the SSIS package which will be executed from the server!!
0
All Courses

From novice to tech pro — start learning today.