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?

Improve company productivity with a Business Account.Sign Up

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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.