I am using a DTS package to simply copy data from an external Oracle RDB ODBC datasource, to a SQL 2000 database.
It works great for most tables.
But one table has over 2.2 million rows...the other system is slow, and averages about 100,000 rows per hour....if I let it go long enough, it hits 800,000 rows and errors out, and of course I lose all the rows since the table is not altimately saved in SQL due to the error.
I'm guessing it's a corrupt table, or row....the vendor wants $$$ to address the issue...
Is there a way, I can "ignore" the errors, and just move on to the next row? I need a way to save the data, even if it encounters an error.
Any help would be greatly appreciated!