SQL Server Bulk Insert Conversion Fail
<p>I am writing a function in C# to create a several Datatables and insert them into a Dataset, then using SQLBulkCopy to insert each Datatable into an Sql Server database. I get this error message: 
<a href="https://i.stack.imgur.com/jdBsP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jdBsP.jpg" alt="Syste.InvalidOperationsException"></a></p>

<p>The exception happens at the column isBuget, which is a bit. The given value is type String? I clearly see 0 in the row I am adding.
    //create reamer table</p>

<pre><code>        DataTable dtreamer = new DataTable();
        dtreamer.Columns.Add("quoteID");
        dtreamer.Columns.Add("line");
        dtreamer.Columns.Add("customer");
        dtreamer.Columns.Add("salesman");
        dtreamer.Columns.Add("quoteDesc");
        dtreamer.Columns.Add("machineModel");
        dtreamer.Columns.Add("machineDesc");
        dtreamer.Columns.Add("isBudgetary");
        dtreamer.Columns.Add("quoteDate");
        dtreamer.Columns.Add("notes");
        dtreamer.Columns.Add("userName");

        dtreamer.Rows.Add(2016099, "Raise bore", "c", "sales", "desc",                                      
        "machineModel", "machineDesc", 0, "01/01/2000", "notes","userName");
</code></pre>

<p>I don't see any conversion. The debugger hits at the "WriteToServer" method of SQLBulkCopy.</p>

<pre><code>   //create data set to hold tables
        DataSet set = new DataSet();
        set.Tables.Add(dtreamer);

        set.Tables.Add(dtlineitems);

        set.Tables.Add(dtcountries);

        set.Tables.Add(dtdiameters);

        try
        {
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                using (SqlBulkCopy copy = new SqlBulkCopy(conn))
                {
                    conn.Open();

                            copy.DestinationTableName = "Reamers";

                            copy.WriteToServer(dtreamer);
</code></pre>