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,

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.

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.

FORCE A FOR LOOP TO STOP AFTER A CONDITION IS MET

khouloud Belhaj 91

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.

User's image

The SAS_PROFILE PACKAGE :

User's image

the expression for the loop

User's image

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

User's image

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,

2 answers

Olaf Helper 45,286 Reputation points

2023-10-17T10:33:59.9033333+00:00

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.
Please sign in to rate this answer.
khouloud Belhaj 91 Reputation points

2023-10-17T10:44:01.4266667+00:00

@Olaf Helper Thank your for you answer , What is the appropriate solution to fix this? Do you have any suggestions please

Olaf Helper 45,286 Reputation points

2023-10-17T11:38:54.23+00:00

Remove the string conversions and the plus quotation mark. Write it like a Excel/math formula.

khouloud Belhaj 91 Reputation points

2023-10-17T12:08:10.27+00:00

@Olaf Helper Thanks I got the point but the expression in the loop doesn't accept a boolean result its only have to be a string.

Olaf Helper 45,286 Reputation points

2023-10-17T12:30:39.5133333+00:00

Then you use somehow somewhere the expression result as string.

Sorry, all a bit confusing.

khouloud Belhaj 91 Reputation points

2023-10-17T14:00:20.0033333+00:00

Yes .. I wish it was a way to force to break out of the loop
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ZoeHui-MSFT 38,371 Reputation points

2023-10-18T06:52:16.5466667+00:00

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.
Please sign in to rate this answer.
khouloud Belhaj 91 Reputation points

2023-10-18T08:25:06.4433333+00:00

@ZoeHui-MSFT Hi, I'm sorry if my purpose wasn't clear.I have a large volume of data , the source is heidi. I can't retreive the data at one. So I created a system that iterate through my data and through a system of monitoring loop all my data. But once it's done the loop continue to run and don't stop.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

FORCE A FOR LOOP TO STOP AFTER A CONDITION IS MET

2 answers

Your answer