Just inherited a package that's pretty simple, twenty-six tables
transfer in parallel, sharing connections, set to default four in
parallel. Only problem is, it starts four, but only one moves at a
time, which you can see when one of the larger ones gets going.

This uses the IBM DB2 client utilities and driver. I gather this is a
single-threaded driver, can anybody confirm?

Thanks.

J.

ps - I see from other postings that one approach is to use multiple
connections. It occurs to me that if I *don't* use multiple
connections, I should at least set my tasks in parallel down to 1,
because DTS locks the source table while it runs, so I'm currently
locking four tables while transferring one (and it's already caused
some problems). Just thinking out loud here. Thanks other posters.


rom: "rusted" <google (AT) precise-it (DOT) co.uk>
Newsgroups: microsoft.public.sqlserver.dts
Subject: Problem: Parallel tasks running sequentially ...
Date: 23 Aug 2006 03:00:32 -0700

From: "IanO" <IanONet (AT) gmail (DOT) com>
Newsgroups: microsoft.public.sqlserver.dts
Subject: Parallel tasks and conections
Date: 13 Sep 2006 13:30:49 -0700