Load CSV file into MS Sql Server Express Edition DB from a Dropbox Folder on Windows 7
Closed - This job posting has been filled and work has been completed.
Load CSV file into MS Sql Server Express Edition DB from a Dropbox Folder on Windows 7.
Basically, i need a script running on windows 7, picking up files from a dropbox folder and loading it into SQL Server Express Edition DB.
Data will be available daily in a dropbox folder. We can setup a windows scheduled task to run a process to execute windows script to load data.
I am not sure why type of parsing / re-formatting we may need. There maybe a number column that will need to be handled differelty. There is also a date / time stamp column that will need to be handled differently.
I will send you the sample files (at day level). You will test loading those using whatever type of script you feel is best to be able to do so.
I can share with you a dropbox folder where files will be.
One thing that needs to happen is that for each file in the dropbox folder, your script will process it and move it to a archive folder so it will not be processed again.
if you can generate an email notifiying me how many records where loaded, it will be great as well.
Again, this is Windows 7 env.
Other open jobs by this client
- Fixed-Price – Mobile only webpage to get users to share a message on Facebook retrieved from mysql DB based on specific location code
- Hourly – Need Virtual Assistant to On-Board New Employees for Our Company
- Fixed-Price – Need to reach out to 50 small, medium size businesses and sell phone service, products