Hi,
I have a table with 18 million rows. I want to load
data from production to dev. I created a DTS pkg. Dropped
all indexes on that table, disabled trigers.
On the DTS Package properties : Advanced Tab, I have these
options checked :
Transactions
Checked "Use transactions", "commit on successfull package
completion".
Trn isolation level is Read committed.
Will it commit after loading all the 18 Million rows or
does it commit after a set of say 1000 records ? How else
can I speed this process up ?
TIA
Mo

Also as a follow up question..
How do I schedule tasks to run parallely using DTS ?
Say I want to kick off Job1 and Job2 at the same time from
the same package ..
Job1 will load data for table1 and job2 will load data for
table2..
TIA
Mo