Download Email Attachment Via POP3 and save to folder
Is there a way to using SQL to download an email attachment from a POP3 server and save the file to a directory? SSIS has a send mail task but not a receive mail task. If not SQL does anyone have any other methods? If you can use third-party solutions, check the commercial CozyRoc Receive Mail Task. You can download from both POP3 and IMAP mail servers and you can also specify criteria what email you would like downloaded. Download of attachments is also supported.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
January 20th, 2011 3:10pm

Is there a way to using SQL to download an email attachment from a POP3 server and save the file to a directory? SSIS has a send mail task but not a receive mail task. If not SQL does anyone have any other methods?
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 3:20pm

I would see if the POP3 server can forward the attachments and have them land in a directory. SSIS has a File Watcher component that can wait for files to arrive and process them as they come in. You wouldn't use SQL in it's truest form to accomplish this, as SQL itself is used to query a database. Coupled with some application programming and you could probably achieve it... Good luck.Brian
January 20th, 2011 3:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics