Hi everyone,
Can someone tell me how to design my DTS to import Reference Tables (those
with Primary Keys) to run in parallel. Since each Ref. table is independent
of each other, i figured that it's much more efficient to import them in
parallel as appose to sequential. However, the question is, how do i design
the DTS to do this, then depending on success/failure, it continues to import
the rest of the tables (those with Foreign Keys).
Source : Oracle
Destination: SQL Server 2000
As a summary, what i would ideally like is as follows:
Get data from Oracle -> Create SQL Temp tables -> Import Ref. tables into
temp tables -> Import other tables (with foreign keys) -> Insert/Update
master tables (SQL)

Any suggestion is greatly appreciated.
Calvin

Draw the package with multiple tasks in parallel, then lead them all to the
single point of convergence, through Exec SQL Tasks.

To ensure you get parallel running, use separate connections for each task,
do not re-use.
Set the Execution parameters, package properties which has a thread limit.

Bandwidth is often the biggest restriction, so ensure you have enough to
make parallel running worthwhile. Also set the batch sizes to a suitable
value - test it.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Calvin KD" <CalvinKD (AT) discussions (DOT) microsoft.com> wrote

Thanks so much Darren. It helped.

Cheers,
Calvin.

"Darren Green" wrote: