Fast CSV file reader for PowerShell impleted as a DataReader.
C# PowerShell
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.

README.md

CsvDataReader

A simple C# IDataReader implementation to read CSV files. This was built to improve CSV performance in PowerShell. The goal is to enable code like the following.

If you download the DLL, you need to Unblock it before you can use it. That's done in the File Properties dialog box.

[System.Reflection.Assembly]::LoadFrom("CsvDataReader.dll")
$reader = New-Object SqlUtilities.CsvDataReader("SimpleCsv.txt")
	
$bulkCopy = new-object ("Data.SqlClient.SqlBulkCopy") $ConnectionString
$bulkCopy.DestinationTableName = "CsvDataReader"
	
$bulkCopy.WriteToServer($reader);