CsvReader throws MalformedCsvException when only some columns are mapped to SqlBulkCopy

Hi,

The behavior of the CsvReader and CachedCsvReader differ from each other when only some columns are mapped to SqlBulkCopy column collection. The CsvReader class throws MalformedCsvException while CachedCsvReader works as expected. The following (simplified from real project) code snippets should reproduce the behavior:

// throws MalformedCsvException at character position 2092
using (CsvReader parser = new CsvReader(new StreamReader(@"C:\Temp\Sample.txt"), true, '\t')) {
    using (SqlBulkCopy loader = new SqlBulkCopy("...")) {
        loader.DestinationTableName = "Sample";
        loader.ColumnMappings.Add("ColA", "ColA");
        loader.WriteToServer(parser);
    }
}

// works
using (CsvReader parser = new CachedCsvReader(new StreamReader(@"C:\Temp\Sample.txt"), true, '\t')) {
    using (SqlBulkCopy loader = new SqlBulkCopy("...")) {
        loader.DestinationTableName = "Sample";
        loader.ColumnMappings.Add("ColA", "ColA");
        loader.WriteToServer(parser);
    }
}

Is this a bug or by design?

The sample input file contains two tab-separated text columns (ColA, ColB) with headers. The sample table contains single text column (ColA).

CsvReader and SqlBulkCopy is expected to pump the content of the first column (ColA) from the input file to the table.

Kind regards, Olli-Pekka Isola

phatcher / CsvReader

CsvReader throws MalformedCsvException when only some columns are mapped to SqlBulkCopy #28