Hi

I'm transfering data from Oracle to SQL via normal transact SQL - not DTS.

So i'm able to transfer a table which had about 192Mio records - final size 105GB.

with

select...

I've had the exactly same issue and I analized the txt file and haven't found any difference in the line where the DTS stopped. As well there was no error...

Hi

with the information_schema you can find what you need too:

select * from information_schema.tables where table_name not in

(select distinct table_name from information_schema.KEY_COLUMN_USAGE)

with this you can find those tables which don't have...

Hi again

I just tried another which I think is more elegant:

select min(fid) from (select top 5 * from #temp order by fid desc) as test

So you don't need to go...

Hi

I'm doing it with a temp table:

set rowcount 5

select field1 into #temp2

from #temp order by field1 desc

select min( field1 ) from #temp2

Hope this helps too.

Roger