Problemer med SqlBulkCopy (string to datetime)

lidt kode:


SqlConnection conn = new SqlConnection(Program.dbConn);
conn.Open();

if (deleteTables)
{
    CleanTables(conn);
}

foreach (var dv in DATSpecificationList)
{
    StreamReader sr = new StreamReader(dv.Value.DestinationTable + ".tbl", Encoding.GetEncoding("ISO-8859-1"));
    SqlBulkCopy bc = null;
    DataTable dt = GetDataTable(dv);

    DataRow row;
    while (!sr.EndOfStream)
    {
        string line = sr.ReadLine();
        if (line.Length == 0)
            break;

        row = dt.NewRow();
        row.ItemArray = line.Split('|');
        dt.Rows.Add(row);

        if (dt.Rows.Count == 50000)
        {
            bc = new SqlBulkCopy(conn, SqlBulkCopyOptions.TableLock, null);
            bc.BatchSize = dt.Rows.Count;
            bc.DestinationTableName = "[" + dv.Value.DestinationTable + "]";
            bc.WriteToServer(dt);
            dt = GetDataTable(dv);
            bc.Close();
        }
    }

    bc = new SqlBulkCopy(conn, SqlBulkCopyOptions.TableLock, null);
    bc.BatchSize = dt.Rows.Count;
    bc.DestinationTableName = "[" + dv.Value.DestinationTable + "]";
    bc.WriteToServer(dt);
    bc.Close();
}
conn.Close();

hmm... man skal åbenbart definere alle colums pr type... + convert alle colums til rette type før den kan æde dataene !!

FFS !