Hi to all,

I am new to dts and sql server and wish to know if this is possible.

We want to know if sql server allows you to run dts's on different machines?
What I mean is some sort of architecture that allocates a dts to a client
machine that does the work and another dts is assigned to another client
machine. Each machine does their own work. I do not want to run the dts's on
the server (i.e. some sort of farming solution).

Is this possible?

Sham.

Hello sham,


This is often accomplished by starting a SQL Server Agent job on the other
box that fires the package.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com