I have a current VB6 project that I need converted to a VB 2010 project. The program's purpose is:
1. Read CSV files from a folder.
2. Format the CSV data for insertion into a SQL Server table.
3. Insert the data into the SQL table.
4. Move the CSV file to a "Processed" folder.
5. Write a log file to a "Logfiles" folder.
The above steps are performed for three different vendors who have slight differences in their CSV files. The total amount of code is about seven pages. The code in the VB6 project works.
The current program is set to run as a scheduled task in Windows Scheduled Tasks and has no user interface. The new program can run the same way.
Requirements of this project:
1. You will need to convert the exact same functionality of the current program to VB 2010.
2. Move the hard-coded items into a configuration file (INI) or equivalent, which will be read by the program upon execution. Items currently hard coded are the folder names where the CSV files are stored, the connection string DSN name for the SQL database, and a command time out.
Deliverables
1. Source code in a Visual Basic 2010 project
2. Compiled executable.
Items Provided
1. VB 6 project file with all the source code.
2. SQL script to create the SQL table where program inserts the CSV data.
3. Sample CSV files.