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 


1. Single CSV file to be read by windows service 

No comments :

Post a Comment