Using ODBC from Navision 2.00 to SQL 7.00

I use ODBC (Ver. 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 ?