I need a very simple windows desktop application that will retrieve a .csv file from a directory specified by an ini file and parse the file contents. It should then update a sql server table based on the file contents and delete the file. sql connection details should also be in ini file. It is 2008 sql server express.
The app should perform the following with the file contents:
1) locate existing records in the table and update based on contents of the file.
2) Add new records that are not found in the table
3) Remove any records from the table that are not in the file based on ID_ITEM in the file
The app will be set up to run automatically from windows scheduler on an hourly basis therefore any error messages must be logged to an error log, no error messages, popups can be generated.
Need this done today!
database table script and the csv file are attached.
This is a very simple app, no frills. Couple hours work if you know what you are doing. You must be ready to get started immediately and complete it quickly. I will be ready to test it as soon as you finish it.
23 freelancere byder i gennemsnit $136 for dette job
You're right, a couple of hours max. I've looked at the files and they are straightforward. SQL Server is 2005/2008? Please check my reviews. My bid: C# console app, logging to Windows event log.