Is there a 3rd party .NET library/assembly that will parse & import files using a metadata-driven approach?

Question

Hi, I need to parse a bunch of delimited flat files and import them into a database. I could build my own simple metadata-driven parser and importer but figure there must be something like this out there already?

Thanks, Dave.

Answer 1

Have you looked into SQL Server Integration Services (SSIS)? It will do this, as well as the sorts of cleanup or other manipulation frequently required after parsing flat files.