DTS performance

[Steve McDonald]

Hi,

Can anyone advise me of a quick way to estimate the time taken by DTS to
import a table (24 columns x 700,000 rows) from JD Edwards (running on
AS400) into SQL Server (new table and no manipulation involved)?

Many thanks,

Steve

[Simon Hayes]

"Steve McDonald" <aj*****@nsw.bi gpond.net.au> wrote in message news:<TB******* *********@news-server.bigpond. net.au>...

Hi,

Can anyone advise me of a quick way to estimate the time taken by DTS to
import a table (24 columns x 700,000 rows) from JD Edwards (running on
AS400) into SQL Server (new table and no manipulation involved)?

Many thanks,

Steve

There are plenty of factors which may vary from one environment to
another, so the most reliable way to find out would simply be to test
it. In theory, you could work out the volume of data (average row
length x number of rows), then divide that by your network speed, add
some time for DTS overhead etc., but in practice I think you wouldn't
get a very accurate answer.

Simon