0

I am trying to download from SOAP API. The supplier has set a limit to download 1000 records per select. I would like to set up "for loop" container to iterate all records in one file.

The Url expect two variables for data i.e Select and Skip. For this I have added two variables @select and @skip and create a web service task and set up the variable with @Select and @Skip.

this webservice task runs ok, but i am stuck on working out a logic to loop through and download all rows in one file.

for the first run the @skip should be 0 for the consecutive run @skip should be previous value of @skip+1000.

Can someone please help to achieve this? Thanks

Improve this question
7
  • How are you stuck on "working out a logic", you've stated the logic in your question: after each iteration, increment SKIP by 1000. So what are you stuck on? I don't understand your question. Commented Jun 3, 2015 at 13:25
  • hi, thanks for response. I am stuck on implementing this logic with for loop task and iterate the data set. Commented Jun 3, 2015 at 13:27
  • Why? What have you got so far, and what part don't you know how to do? Commented Jun 3, 2015 at 13:28
  • hi, i am not sure how i can set up the initial value for @skip to be 0 and and add 1000 for each run. Commented Jun 3, 2015 at 13:32
  • You can perform both actions with script tasks. Commented Jun 3, 2015 at 13:34
Related questions
0
SSIS variable scope- for loop cannot see user variables
0
Foreach loop container in SSIS using variable
0
SSIS For Each Loop
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.