Corrigenda, Errata for the “Parallel Load CSV Using SqlBulkCopy”.


This post is a “patch up” for the post I made yesterday. The “Parallel Load CSV Data Using SqlBulkCopy” blog posts has one omission.  I have forgotten to post one of the source files. The missing file was the SqlLoadResults class. This file is included below.


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ParallelLoader
    /// <summary>
    /// Internal class, could be public of you wanted to pass the results out further
    /// </summary>
    internal class SqlLoadResults
        #region FileName being loaded
        private string _fileName;
        public string FileName
            get { return _fileName; }
            set { _fileName = value; }
        #region Start Time
        private DateTime _startTime;
        public DateTime StartTime
            get { return _startTime; }
            set { _startTime = value; }
        #region End Time
        private DateTime _endTime;

        public DateTime EndTime
            get { return _endTime; }
            set { _endTime = value; }
        #region Rows Loaded
        private long _rowsLoaded;
        public long RowsLoaded
            get { return _rowsLoaded; }
            set { _rowsLoaded = value; }
        #region Rows Skipped
        private long _rowsSkipped;
        public long RowsSkipped
            get { return _rowsSkipped; }
            set { _rowsSkipped = value; }
        #region Elapsed time
        private long _elapsed;
        public long Elapsed
            get { return _elapsed; }
            set { _elapsed = value; }
        #region Rows Returned
        private long _rowsReturned;
        public long RowsReturned
            get { return _rowsReturned; }
            set { _rowsReturned = value; }
        /// <summary>
        /// Constructor for the class
        /// </summary>
        /// <param name="fileName">File which was loaded</param>
        /// <param name="start">Date Time the load started</param>
        /// <param name="end">Data Time the load ended
        /// rowsLoaded">Count of the rows loaded
        /// rowsSkipped">Count of rows skipped</param>
        /// <param name="elapsed">Clock ticks for the duration
        /// rowsReturned">Rows returned from the Data Reader</param>
        public SqlLoadResults(
            string fileName, DateTime start, DateTime end,
            long rowsLoaded, long rowsSkipped, long elapsed,
            long rowsReturned)
            this._fileName = fileName;
            this._startTime = start;
            this._endTime = end;
            this._rowsLoaded = rowsLoaded;
            this._rowsSkipped = rowsSkipped;
            this._elapsed = elapsed;
            this._rowsReturned = rowsLoaded;

, , , , , , , ,

  1. #1 by Glen Martin on February 25, 2011 - 6:24 am

    Hello Craig,

    For some reason, I couldn’t post a comment on the same page as the following article:

    I have a question about the Boss, eBand, if you don’t mind.

    Is it possible to have the FS-6 foot switch connected at the same time as a Wah pedal?

    Also, are you still ‘digging’ the Boss eBand ? 🙂

    I’m also a software developer. I live in the Seattle WA, USA area.


    • #2 by aussiecraig on February 25, 2011 - 6:40 am

      I reason why you could not comment is probably one of the default settings here on WordPress. The “comments open for”, which defaults to one month. I’ll have a look at changing that setting.
      On the FS-6 and Wah pedal, I don’t think you can use both. The eBand has only one input “hole” for external pedals. If Boss did a combo switch and Wah, then you’d be in business. But, the settings in the eBand for an external input are pretty flexible. It could be possible that the Wah could be used as a switch (all up, all down switching). I don’t have a Wah pedal, so I cannot test it. The user manual for the eBand is on the Boss web site as a pdf, maybe you could download and have a read.
      Yes, I still dig the eBand. I use it all the time when I’m practicing. Having 100+ effects with “sane” names, in logical groupings, an backing track playback/play along is great.


      • #3 by aussiecraig on February 25, 2011 - 6:44 am

        I just change the comment cut off to “no cut off”. It was set at 30 days, which was the default value.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: