Download Email Attachment through SSIS

Question

Download Email Attachment through SSIS

rocky_498

SSCertifiable

Points: 6532
More actions
February 19, 2015 at 11:11 am

#398045

Hi,
I am using IBM Notes (Email services) not Outlook. I want to download Email attachment from SSIS.
Please advise.
Thank You.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

if your email server supports a standard POP3/SMTP interface, it's possible, but complicated code, since it would involve c#/vb.net code in a script task, and of course requires a lot of extra logic: besides the classic connection information, you need to pull all? emails from the email server, and for each attachment in each email, download them and save them to disk, right?

can you assume that every attachment needs to be saved form every email? will you be saving Viagra.jpg from random spam emails? only specific extensions?

you need to also delete the email after you pull it, so that you don't redownload it all over again.

without more details, i can just push you towards code examples:

https://www.google.com/search?q=c%23+pop3+download+attachments&oq=c%23+pop3+download+attachments&aqs=chrome..69i57.6867j0j7&sourceid=chrome&es_sm=93&ie=UTF-8#q=c%23+pop3+download+attachments

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!

rocky_498 SSCertifiable Points: 6532 More actions · Answer 2

I just want to download only where email is abc@hello.com (as an example) and download the attachment on network drive folder.

Is there any third party software doing this ?

Lowell SSC Guru Points: 323504 More actions · Answer 3

rocky_498 (2/19/2015)
I just want to download only where email is abc@hello.com (as an example) and download the attachment on network drive folder.
Is there any third party software doing this ?

https://www.google.com/search?q=ssis+pop3&oq=ssis+pop3&aqs=chrome..69i57.6850j0j7&sourceid=chrome&es_sm=93&ie=UTF-8

from one of the links here, the guys from CozyRoc had something back in 2010:

http://www.sqlservercentral.com/Forums/Topic783332-148-1.aspx

CozyRoc (6/8/2010)
If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. It supports both POP3 and IMAP for connecting to mail server.

it's a big freaking task, i'm telling you though;

i did a proof of concept to do this before, and it was a very deep rabbit hole to fall into.

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!

rocky_498 SSCertifiable Points: 6532 More actions · Answer 4

Yeh 100% agree. I have to do something to make this happen with your help 😀