We are like SSIS heavy shop and there are more than 30+ packages that runs in that 24 hr cycle. However, lately every few other weeks we are noticing that the packages fail to execute and throws out this error provided below in the job log. Our packages are configured either through SSIS catalog or through packages stored in msdb. However, both of them are failing. I came across one of the articles from Microsoft and this is the only article that is an exact replica of what I am facing in my environment but even after applying the same solution I am back to square one with the error re-appearing. I've provided the environment details below. Can someone point me in the right direction.
Executed as user: x. The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.
SQL Environment Details:-> SQL Server 2012 SP3, Windows Server 2012 Datacenter (x64), RAM: 28 GB, Only a single SQL instance running on the machine and there maybe a couple of other services but that's all.