Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Save mail files(.msg) from Mail Server using SSIS

Author  Topic 

bhushan_juare
Starting Member

45 Posts

Posted - 2012-09-05 : 07:31:44
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

52326 Posts

Posted - 2012-09-05 : 21:59:55
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
   

- Advertisement -