Using ODBC from Navision 2.00 to SQL 7.00

I use ODBC (Ver. 2.11.05.00) to tranfer data from Navision Financials V2.00 to SQL 7.0 using DTS. Sometimes not all data have been transfered even if no error is displayed from DTS. 2 Tables have 1.500.000 records. The problem may be for tables dimensions??? Anyone know Why ?. Thank you very much. Maurizio Riccardi

… No ideas out there ?