MySQL's fetched DataSet field MySQLDateTime to DateTime

See more:

C#

Query summary: the datetime column in a dataset(fetched from MySQL) is of type MySQLDateTime, which holds null values as 0000-00-00, which is incompatible when i try to bulk insert in SQL server....which gives this error

MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime

the code is as follows;

MySqlConnection connection = new MySqlConnection(mysqlConnString);
                    connection.Open();
                    MySqlCommand command = connection.CreateCommand();
                    command.CommandText = "SELECT * FROM ` orders`;";
                    MySqlDataAdapter myda = new MySqlDataAdapter(command.CommandText, connection);
                    myda.Fill(ds, sTableName);

the above works find and ds include the northwind's order table's empty date values

using (SqlBulkCopy bulkcopy = new SqlBulkCopy(trans.Connection, SqlBulkCopyOptions.Default, trans))
                {
                    bulkcopy.DestinationTableName = "["+sTableName+"]";
                    bulkcopy.WriteToServer(ds.Tables[0]);
                    cConvertor.AddTextOutputtoFile(ds.Tables[0].Rows.Count.ToString() + " row(s) have been added to " + sTableName + ".");   
                }

Please advise