Emailing data between different SQL servers


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

    Montag, 24. Juni 2013 09:48


  • 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.
    • Als Antwort markiert Fred Wallace Dienstag, 25. Juni 2013 09:08
    Montag, 24. Juni 2013 09:58