I'm using an ODBC connection to connec to a data source to import data into SQL Server 2005. I have no problems setting up the connection and the data transfer works fine on a small sample of data (doing a SELECT TOP 100 * FROM <table>).
This issue is that when I try to pull down the full table, I get a timeout on the ODBC connection. I've turned on the 'Save long running queries to the log file' and tried to change the 'Long query time (milliseconds)'. Problem is the maximum value I can enter in this field is 99999 which is only 99 seconds. I've also tried entering 0 thinking that would be the unlimited setting. Neither of these options work.
Is there anything I can do?
Note: This is a one time data transfer and I really do not care if it take 3-4 hours to run as the total table contains almost 1 million records