We are an online retailer and receive our orders via email. We need to monitor a gmail account for new emails containing a specific subject line and a CSV file. The CSV file needs to be extracted from the email, sanitised and imported into a Microsoft SQL 2008 server database.
The first line of the CSV contains the customers details and the second and subsequent lines the order items
There are stored procedures on the SQL server that can be used for the import.