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