Hi,

I have a folder in the server which is populated with collections (in form of csv.files). I have SQL 2005 installed in the server and can use to communicate with the folder.

My task is:

1) Automate a process to check if there is a new csv file for a practice in the folder. If yes, then update a table in the SQL database by incrementing a field called col_uid and set flags to send and receive as true.

I DO NOT need to do any data transfer whatsoever.

Whats the best way to approach this task..

A colleague suggested to have an application to run through the folder to check for new collections by creating a VB.NET application - (then have a scheduler to run the application)..

Then create a trigger where when a new collection comes in it creates the colu_uid and updates the send and received fields...

Any ideas please.. many thanks