Use an iteration using SQL query OFFSET

[kakooo16]

Hello guys ,  

The problem is i have 22000 items but i want to pass 1000 items in each iteration .

Here is my job is as such 

My query is as such 

My question is how do i have to configure my tloop to achieve this problem .

Thanks guys .

[billimmer]

Ok, it looks like your "All_Items" will contain

1 thru 10 on the first pass, 

1 thru 20 on the second pass,

1 thru 30 on the 3rd pass.  

Because you add to it on each pass.  This is not what you want correct?  So maybe use the tReplicate to send one "main" to "All_Items", and a second "main" to process only 1-10, 11-20, and 21-30.  Something like this...

[billimmer]

...Or on the second tReplicate, connect it to another tHashOutput but uncheck the "Append" option

[kakooo16]

OKey , Thanks a lot i will try both solution and will give you a feed back as soon as possible !

Greetings