Ignore Errors???

Last Post 27 Mar 2008 11:28 AM by dstoltz. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dstoltz
New Member
New Member

--
27 Mar 2008 11:28 AM
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...

MY QUESTION:

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!

Thanks!


Acceptable Use Policy
---