<div>
You can read emails from Exchange Server into SQL Server via the scripts provided here:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/bb508823%28EXCHG.80%29.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/bb508823%28EXCHG.80%29.aspx</a><br />
<br />
Do Note that it is not recommended to use these scripts in Production Environment..
</div>


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 [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..

<div>
You mention Outlook 2003 - can you confirm what version of Exchange you are using? 2003,2007 or 2010.
</div>


You mention Outlook 2003 - can you confirm what version of Exchange you are using? 2003,2007 or 2010.

<div>
And missed mentioning one more thing..<br />
<br />
* SQL Server can send emails which can be read in Outlook but SQL Server can't receive or read emails from Outlook.<br />
* Above approach mentioned in my link suggests a way to read emails directly from Exchange Server and not from Outlook.
</div>


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.

<div>
rrjegan17: - i really need to be able to read a mail from the SSIS package which will be executed from the server!!
</div>


rrjegan17: - i really need to be able to read a mail from the SSIS package which will be executed from the server!!

<div>
<div class="content wysiwyg-content">
I need to access a specific E-Mail folder from an SSIS package created on a SQLServer 2005.<br />
The server does not have Outlook installed (this is a company decision).<br />
<br />
I need to read the emails and extract data to input into a SQL dB. &nbsp;Inputing the data into a dB is no problem just the access to and reading of the emails.<br />
<br />

</div>
</div>


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.



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

An email client, email reader or more formally mail user agent (MUA) is a computer program in the category of groupware environments used to access and manage a user's email. A web application that provides message management, composition, and reception functions may internally act as an email client; as a whole, it is commonly referred to as webmail. Likewise, email client may be referred to a piece of computer hardware or software whose primary or most visible role is to work as an email client. Email clients can also have other systems, like calendars, notes and contact managers.

Email Clients

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.