Import Email Attachment

• scotsditch

  Ten Centuries

  Points: 1020

  More actions

  January 16, 2014 at 9:13 am

  #396119

  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?

• Kevin Galbreath-373973

  Right there with Babe

  Points: 759

  More actions

  January 16, 2014 at 11:47 am

  #1680805

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

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

• trish972

  Valued Member

  Points: 61

  More actions

  May 25, 2016 at 8:14 am

  #1881328

  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,