Save mail files(.msg) from Mail Server using SSIS

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources