SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Save mail files(.msg) from Mail Server using SSIS		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bhushan_juare
Starting Member

44 Posts
Posted - 09/05/2012 :  07:31:44  Show Profile  Reply with Quote
Hi Guys,

I am working on SSIS packge where I want to save mail files(.msg) coming from Mail Server along with attachment using SSIS 2005
Kindly provide links if its possible...

Thanks & Regards,
Bhushan

visakh16
Very Important crosS Applying yaK Herder

India
47152 Posts
Posted - 09/05/2012 :  21:59:55  Show Profile  Reply with Quote
are you saving messages in some file share. If yes, you can configure a for each loop in ssis to iterate through files in folder and do required processing.

see below as an example (its using text files in example)

http://visakhm.blogspot.com/2012/05/package-to-implement-daily-processing.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000