ANN: CsvReader 2.0 Released

http://www.csvreader.com

One of the most common tasks involving CSV data in a Microsoft
environment is to bulk insert data originating from a CSV file into SQL
Server. In the .Net Framework 2.0, MS added a new rarely talked about
class called SqlBulkCopy that allows for bulk inserting data from
another datasource directly into SQL Server at almost DTS speeds. This
new method is much faster even than the new batch insert ability of the
SqlDataAdapter that everyone keeps talking about so much. This is the
focus of the 2.0 version of the CsvReader framework and the basis for
the new class CsvDataReader. Unfortunately, you won't be able to take
advantage of this if you're still using .Net 1.0 or 1.1, but it might
give you a reason to upgrade. Now, even tasks like validating data or
manipulating data before insert even becomes a breeze using the
ReadRecord event that allows you to add data, modify data, even skip
whole rows on the fly while your data is being inserted. It does not
require SQL Server 2005 to use it.

http://www.csvreader.com

.

Relevant Pages
Loading