Weird stuff, having random failures the past 3 nights in a row during nightly processing. 1.Child packages are run by the parent 5 times before failing the job that runs the parent, when this happens, the child is manually reset and ran again and then it completes on the first try sometimes, and sometimes not for the 4th or 5th try, sometimes requiring running it manually in BIDS, where it completes successfully.
2.Due to this delaying downstream processing some jobs are manually turned off but then they are still running somehow
3.tables being empty even though the package didnt fail
Any help is greatly appreciated!