Hi!

I've create a simple DTS that transfers a table's data from SQL Server 2000
SP3a to an Oracle 9.2 table using the MS OLEDB provider for Oracle. This
process is done daily. Currently, the table on the Oracle server already
contains 200,000 rows and it seems that DTS is doing something like a "SELECT
* from Table(on Oracle)" before starting the transfer. I don't know why it's
doing it since the transfer is from MS SQL Server to Oracle...

Has anymone ever encountered this? The table on the Oracle server will
eventually contain > 100 millions rows. If DTS does a "SELECT * from ..."
everytime we run the DTS (everyday), it will get very slow very fast.

Please help.

Thanks.

Patrick