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 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