asked
Retry logic SSIS Package
Hi everyone, Currently I have a simple ForEach Loop Container that loops a list of SQL Server instances and get some data and stores on a table. However, sometimes it seems that the SSIS Package can not connect on the server, maybe a network outage or anything else. I was wondering if it is possible to create some logic to output a list of servers that the SSIS Package did not connect or failed and then implement a retry logic. Does anyone of you knows if this is possible? I have very limited skills on SSIS, so I don't know if would be possible or not. Thanks, Marcos
You could use an error handler on the the data flow task to output each failed server into a list (maybe a local table or flat file) I would be wary about automatic retries as whether it is worth retrying depends on why the server failed (if it has been decommissioned and left on the list you wouldn't want it to keep trying indefinitely). If you absolutely must automatically retry, you'll need to store the failure details in a table so you can establish a failure count and so be able to ignore items that have failed several times
15 People are following this question.
