I'm recieving some CSV files from our clients and they are supposed to be
written in the Database.Considering the following issues:

1) The CSV files should be hughly validated,each field against a lot of
bussiness rules
2) Everything must be logged
I) Invlaid Field Values
II) Errors and Warnings happened during pumping data from CSV into
DB
III)All other Error and Exceptions

I choose to have a Windows Service which monitors a folder for CSV files and
picks them up as soon as they are created and after validation( Parsing +
Validating) ,executes a DTS package (anything happenes in DTS ,windows
services gets notified) .there is also a log component in the Windows
Service which logs everything.

I just wanted to know if anybody has the experience.I'm looking for the best
strategy actually.

Thanks

Ali-R