All these projects are listed in priority ranking of which one to be done first

1) We have a page where data is posted to from a lead supplier (pages attached). It is an asp page on a windows server, data goes to a mssql db, hosted by discountasp.net.
a. I want to add the ability that when the data is posted, an html email is sent back to the email address submitted and another email is sent to a specific email with the fields from the post.
b. Since the leads go to more than one client, I have it setup that the code reads the last digit of the phone number and if it is above or below a number it goes to a specific client. Very basic, I would like that changed for the code to read what “second” it is therefore I can distribute according to time stamp instead of phone number.
c. I also want the ability to have a different auto respond email for each client. So I just need to know what page to add or edit with the new html email.
d. I would want it easy for me to visually view the code and determine how to add clients or suppliers or change the parameters.
2) Automate
a. Daily I get an email with a link in it to a page which has a link to csv file to download and a download button. (the name of the file changes daily).

b. I would like to automate that when I get the email, I am able to download the file, and then import into an MSSQL database
3) Automate
a. Daily I download a file from an SFTP site, and then upload to a MSSQL DB, then run a couple of queries. I have the queries written as opposed to a stored procedure or trigger. It is a daily file, but it does not always come at the same time. But we do want to get it as soon as it is there.
b. I want to automate the download, upload, updates and appends into my MSSQL DB.
4) Automate
a. We have two databases (one is MySql the other MSSql) that are used for different reasons by two different companies but have a same table. I need to daily take the updates and appends from the Mysql db and move it the MSsql db and update append the table that is there.

5) Every year I get this database http://shop.delorme.com/OA_HTML/DELibeCCtdItemDetail.jsp?item=27869&section=10121 it allows to export 10k records at a time, and I have automated it in the past to export the 10k to a file over and over again etc, but it takes forever. And then I upload to a db. Is there a easiser and quicker way to get the data either via scrapping from the cd or exporting more then 10k records at a time. I will supply the dvd to use.


You can bid on all projects combined, but I would like a breakdown of each of hte projects, and as each is completed, I shall make payment. It is o.k. if you cannot do all of them, just bid on what you can do.