Hi,
When I try copy some data from remote (ODBC) SQL serverer to local SQL Express using SqlBulkCopy I saw that I have to few rows.
First I downloading data to dataSet from remote SQL server using ODBC:
OdbcConnection dbConn = new OdbcConnection("DSN=" + settings.ODBC_DSN + ";uid=" + username + ";pwd=" + password);
OdbcDataAdapter dataAdapter = new OdbcDataAdapter();
DataSet dataSet = new DataSet();
try
{
dbConn.Open();
dataAdapter.SelectCommand = new OdbcCommand(sql, dbConn);
dataAdapter.Fill(dataSet, settings.RECIPES_TABLE_NAME);
CopyTable(dataSet.Tables[setting ...
Go to the complete details ...