The best way of transforming CSV files into Database

[ALI-R]

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

 

[Jeffrey Palermo, MCAD.Net]

Ali,
There is no shortage of resources to help you with this. Here are
several tutorials addressing this very issue:
http://www.heikniemi.net/hc/archives/000152.html
http://www.codeproject.com/useritems/CsvReader.asp
http://dotnetjunkies.com/WebLog/chris.taylor/archive/2004/04/09/11039.aspx
http://www.codeproject.com/cs/database/asc2xxx.asp
http://www.ftponline.com/vsm/2004_11/magazine/columns/net2themax/default_pf.aspx

Best regards,
Jeffrey Palermo
Blog: http://www.jeffreypalermo.com