Skip to content

Latest commit

 

History

History
19 lines (9 loc) · 614 Bytes

README.md

File metadata and controls

19 lines (9 loc) · 614 Bytes

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);