I used the following SQL query to insert data into another table using
DTS connection. I thought that following will insert the rows from a
table 10 times into the destination database. However, insertion is
done only once.


DECLARE @count integer
SET @count = 0 WHILE @count
< 10
begin
SET @count = @count + 1


SELECT *

FROM Categories

end

I am not sure what a SQL Connection is. Are you using an ExecuteSQL task or
a DataPump task?

Is the source and destination on the same server? If they are then it would
be best to write the INSERT here as well.

In DTS You could also loop over the same row 10 times in a Script transform
and insert a row every time if you wished.

The use of * is generally not recommended as when table definitions change
the query could break and also you can potentially be bringing back a lot
more rows than you need to.



--


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



<aslamCS (AT) gmail (DOT) com> wrote