Synchronization csv file to SQL Server 2008 R2 Database

Question

Hi everybody,

I am making a simple tool to synchronize data from csv files to SQL Server Database.

My SCADA Signal transfer data through csv files (3 SCADA signals --> 3 csv files) and datas will be transfered 1time/1day.

And I will make a simple tool, read csv files and import to SQL Server Database.

My issues are:

1. I have no ideas how to handle the csv files when they were transfered back with diffirent names.

2. How to set time to synchronize (1time/1day).

3. Can I make a windows service to synchronize?

Please help me.

If you have the user interface for issue 1, please give me!

Thank you very much