I'm trying to upgrade my access forum to my new MSSQL. Everything goes fine with creating tables from setup but I get errors when copying 6 of the tables with DTS. The problem is that I can't see the detail of the error. It just says: ERROR AT DESTINATION FOR ROW NUMBER xxx. ERROR ENCOUNTERED SO FAR IN THE TASK. 1
That doesn't say much. On the final dialog window, where the several tasks are shown, there is a status column that should provide a (hopefully more) descriptive error message. Have a look at it.
For those who could encounter this problem, There were not enough space allocated to the MSSQL destination DB. This problem was creating that mysterious error message
Topic Locked
Posted - 14 August 2005 : 02:25:56
