Retry after failure

[DeanRHolden]

I'm trying to modify a SSIS package that gets XML from a web API to retry if it fails to connect or get data from the API. I'd like it to try a number of times before really failing. I've tried a for-loop with a retry variable that is set on failure, but when the XML source in data flow times out because the API is busy, the package fails, and it stops.

Has anyone done something like this, and if so can you give me some tips?

Thanks,
Dean

 

[cmartin75]

You can set the property MaximumErrorCount of the for-loop to the number of retries you want to re-execute the web API request.

I only test it on the results of a script task, but I think it should works.