Greetings and thank you for reading my question,

I am relatively new to DTSs and I have run into an issue. I have a SQL
Server DTS that reads data from several Oracle tables and saves the data into
one Oracle table that is then used for reporting. The trouble that I have
run into is that the DTS is taking a very long time to execute. The package
does a very simple transformation just to map columns. The DTS seems to be
executing a "Select rowid" query internally against the one destination
'master' table every time it executes. That destination 'master' table has
over 18 million rows in it and so it takes quite a while to return the
results of that query.

Does anyone happen to know why the DTS needs to run that query against the
destination table and is there any way to stop it from doing so?