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

SSC Guru

Points: 323506

September 5, 2012 at 6:03 am

I've done this in code in vb.net/c#.net, where you pull messages from an SMTP server, and then you can do what you want with them: delete them off the mail server, save the messages, save the attachments, etc.

I would reckon in SSIS you'll have to put the same code in place; i don't remember seeing a component to read email directly.

you could also create some CLR methods to do the same work as well, since it's the same code.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!