I want to tranfer data from 10 tables from server a to server 2.
for this what is best approach and why ?
1. make seprate DTS for each table
2. make one DTS for each table

If it's really that simple, you shouldn't have a problem putting them all
into one package.

If you want to re-run portions of the package, that would be a good reason
to break them out to separate packages.

Also, if you are concerned about recovering from errors by re-running
individual tasks, that might justify splitting them up.
--
Cheers,

'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com

"Vikram" <aa@aa> wrote

Hello Vikram,

There is no "Best" tool IMHO. Different things work in different situations
and different tools suit different people.

For your situation using DTS I would have 1 package with 10 Transform Data
Tasks.


Allan