sql server dts: Hello,

I have about 55 clients for which I need to process data. There will be as
many as 5 steps to move data from one database to the other, transform the
data and then final processing of the data.

Question 1:

Can I execute multiple SQL Tasks at the same time? I would need to start
some task and query the data. While that data is querying, I would like to
branch back up the beginning of the package and start the SQL Tasks for the
next client? Or do I need to execute one package all the way through and
then branch back up to the beginning step to process next client?

Question 2:

If I can't have multiple SQL Tasks executing at the same time in the same
DTS pacakge, should I create 55 client DTS packages? I could then have one
master DTS package start and load a client package. Then question then would
be would I be able to start and execute multiple packages that would be
processing at the same time?

We are currently doing this in a UNIX environment. We are trying to migrate
this functionality to SQL Server.

Thank you for your help in this.

On Tue, 7 Aug 2007 10:32:02 -0700, Webtechie
[quoted text, click to view]

Hello.


[quoted text, click to view]

Within a single package, DTS will start and run multiple threads
(defaults to 4) at the same time.

[quoted text, click to view]

You can run as many copies of a package at once as you might like.

On the other hand, it is likely that just a couple of packages will
pretty much max out performance, trying to run 55 together would be a
bad idea.


[quoted text, click to view]

All possible.

J.