Sample Header Ad - 728x90

SQL Server Integration Services (SSIS) Package Failing with no error

1 vote
1 answer
2158 views
I have some SSIS packages that are executed as steps in a Server Agent Job. The Steps often fail with no error and I have had to add retries. Now the jobs complete but I get the warning exclamation mark telling me there has been a failure and its these steps that nearly always require a retry. When looking at the failed step in the Job History I can see the package execution log and then it just randomly cuts off and the step beings a retry. There is no consistency with where it stops and I know there isn't a problem with the package as it eventually succeeds. Does this sound like a network related issue? Is there anyway to find out what is causing these failures to happen?
Asked by Michael (11 rep)
Sep 19, 2019, 08:32 AM
Last activity: Jan 31, 2022, 02:07 PM