1. Windows service with pre-defined schedule for reading CSV file data.
2. Loading the CSV file data into a data table.
3. Using SQLBulkCopy to save the CSV file data into a database table.
4. Moving the source file to different folder after successful processing
5. Creating an installation setup project using the InstallShield
6. Registering the windows service
1. Single CSV file to be read by windows service
2. CSV file first row contains the column names.