I have an older .Net Windows Service that I am converting. The Service polls ISAM files and gets the latest records. The Service creates an ODBCDataReader for reading the ISAM files.
The conversion requires that I read the ISAM files and then write the resulting dataset to SQL Server.
Once I have the ODBCDataReader filled, then is there an easy way to write this data to a SQL Server 2005 database. Currently the application is using a very long ConvertDataReadertoDataSet
function that is timing out some service running on the Linux box. I don't have any control over the Linux box so I have to make this work from my end.
I have attached the function that is being used that is timing out the service. The column count is 45 which is chewing up time ConvertDataReaderToDataSe1t.txt