none
Emailing data between different SQL servers

    Question

  • We use external sql server to send automated mails to a team members mail boxes. After that, we convert them into csv, and import onto our internal sql server.

    How can we send the mails directly to our sql server so it can automatically process the data from emails?
    We don’t control the external server’s config or output.

    Monday, June 24, 2013 9:48 AM

Answers

  • I must say that there is no default way to do this. I recommend that you create a custom application which can:

    1.    Check the mailbox
    2.    Parse the results
    3.    Insert results into database

    The app itself doesn’t have to be on the server, but it has to be able to connect to it.
    • Marked as answer by Fred Wallace Tuesday, June 25, 2013 9:08 AM
    Monday, June 24, 2013 9:58 AM