Need SQL server to recive email with data in an attachment
Hi All Hope someone out there can help me, here is the situation I have: I have a database on a SQL 2008 server and an external company will be sending daily emails with an attachment that is a Text file with TAB delimited data. I need to get that data into the database. I can create the SSIS package to read a flat file (the Text file attachment) and import it, thats no problem. The issue I am having is how to automate getting the email attachment to a location that SSIS can access it using either Exchange or Outlook. I would prefer not to have to leave a copy of Outlook open, and 3rd party apps are probably out of the question. Does anyone have any ideas? Thanks John
February 9th, 2011 5:55pm

Write a program in .NET that will read email and save attachment on disk. If you have Exchange you can try for example using EWS.With kind regards Krystian Zieja http://www.projectnenvision.com Follow me on twitter My Blog
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2011 6:38pm

You can put that code into a Script Task, or use the Download Mail Task from CodePlex that works with a POP3 server. There are also some 3rd party solutions you can find on the SSIS Community Tasks and Components site. Talk to me now on
February 9th, 2011 7:02pm

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

Other recent topics Other recent topics