As said in my earlier query, I am using a DTS package to import data from
multiple SQL Server 2000 server database. They are all alike and hence I have
a common data pump task. I run a loop to change the connection setting of the
source in the data pump task.

I have certain lookups defined in the Data pump task.

When I run the DTS package, it does loop through the multiple servers,
transforms the data as designed. But the problem is that it limits the number
of rows imported to the rows imported in the first cycle of the loop.

Ex: if my source server 1 has 200 rows and source server 2 has 1500 and a
third server that has say 25000 rows, my DTS imports just 200 rows from each
of the servers when i run it.

Striking point is that when i execute the data pump task individually on the
three servers, it imports all the data.

This is really quite frustrating at times.

Any help appreciated.

Never seen this one before. What happens if another server goes before the
200 rows server? Is 200 rows a full dataset? What is the source statement?
query or proc or table?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Vikram Kamath" <VikramKamath (AT) discussions (DOT) microsoft.com> wrote