Import Email Attachment

  • Hi, I get emailed excel and csv files each day at work.

    I'd like to create an ssis package that I could schedule to import the data from the files attached to the email into a sql server database.

    I don't want to have to manually download the attachments and then run a package, I would like it to import automatically from the email.

    Does anyone have a suggestion on how to do that?

  • Check out MailSystem.NET on CodePlex [/url].

    I managed to get a C# script task in SSIS working to download attachments from GMail.

  • Hello,

    I would like to do the same kind of package but I really don't know which script to write.

    Could you please help me for this. I'm working on ssis 2014 and Visual Studio 2013.

    Regards,

Viewing 3 posts - 1 through 2 (of 2 total)

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