Post reply

DTS - importing data from oracle

  • June 16, 2006 at 2:23 am

    #112669

    I'm currently transferring data from oracle 8i to sql server 2000. the data from oracle is more than 2 million records. during the transfer the dts stops at 812900 and says it has completed the transfer. do dts have limitations od trasnferring data from other sources.

    Thanks

  • June 16, 2006 at 7:08 am

    #644241

    No, it shouldn't have any trouble.

    Are you obtaining the data directly from a table or from a SQL query.  If the latter, I'd try running the query (but with a count(*) rather than your columns for the select statement) to see how many rows the query returns. 

    If from a table....  Again, perform a select count(*) from MyTable in Oracle and see how many rows it indicates..  I'm very very far from Oracle guru or even novice status - does Oracle have any form of row level security?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply