FORCE A FOR LOOP TO STOP AFTER A CONDITION IS MET

Question

Hello everyone,

have a need to collect volumetric data from a source, but because I couldn't retrieve all the data at once, I created a system that collects 10,000 lines at a time. I also updated a monitor to advance to the next set of lines.

The SAS_PROFILE PACKAGE :

the expression for the loop

Every thing works fine except that my treatment doesn't stop once the condition is false

This results when all the data get inserted turns to be 0 so as a result in the expression we have 0>0 which is false but it continues to iterate through the loop.

Any help will be appreciated!

Best regards,

Answer 1

result in the expression we have 0>0 which is false but it continues to iterate through the loop.

No, you don't get it, you "add" some value and get a string "0>0", not a comparison result.

Click on button "Évaluer l'expression" and you will see it.

Answer 2

Hi @khouloud Belhaj，

I‘m not clear about your need, could you describe what you want to via SSIS?

If you want to load data every 10,000 lines, you may refer to this blog.

If not, please incorrect me.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.