locked
Import data from Email Attach (Integration Services) RRS feed

  • Question

  • Hi,
    I want to create package in SSIS and import data from Email attachement(csv) or Email Body then load in Sql Server tables
    Tuesday, April 14, 2009 11:07 AM

Answers

All replies

  • There is (at least) one Task at SSIS Community Tasks and Components that will connect to a POP3 server to download mail and attachments...
    Todd McDermid's Blog
    • Marked as answer by Tony Tang_YJ Monday, April 20, 2009 10:00 AM
    Tuesday, April 14, 2009 4:44 PM
  • Hi,
    I want to create package in SSIS and import data from Email attachement(csv) or Email Body then load in Sql Server tables
    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.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    Tuesday, June 8, 2010 12:52 PM