Current Situation: I have a HTML web form for contact requests. Currently, the user submits a request and an email with all of the information is emailed to our system and then we pick it up and import it into our database (our database is not an SQL DB). There are some data integrity issues with this system.
I'm looking for any somewhat detailed suggestions on getting this information (after each individual submission) to us in a better way. Maybe trigger a DTS and put a text file on a FTP server that we can retrieve. Not familiar with DTS or really any other method so I'm not sure how this would work.
Any and all suggestions are welcomed. Thank you.