Jump to content
  • 0

Run task on more than the limit of records



8 answers to this question

Recommended Posts

  • 0

1) Create an autonumber ID field on your table datasource.

2) On your task, create a where filter which will only process the records where id field is less than 6000 (assuming that your table has 120,000 records)

3) Duplicate this task, however, this time, set the where to filter to only include records where id field is greater than 6000.

4) Set them to run for atleast 30 mins apart. (Just a suggestion)

Hope it helps.


Link to comment
Share on other sites

  • 0

I just discovered a new way of solving this!

What I did is I created an extra yes/no field on the table that I'm processing. 



All I have to do after that is to run the task again and again until all records are updated. The value on the TOP can be adjusted to estimate the maximum amount of record involved per run.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...