Monday, December 19, 2016

Part 1: Step by Step guide to create, install & register windows service in visual studio 2013 to read single CSV file and save data in a database table

Points covered in this video are: 

 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 

Assumptions: 

1. Single CSV file to be read by windows service 

No comments :

Post a Comment