2

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.

SSIS package fails with error : The step did not generate any output. The return value was unknown

Message:

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.

  • To confirm: Your package is set up to use SSIS Logging, you're set up to log messages OnError and OnWarning, and nothing is being logged? And, all SSIS packages run by jobs are failing, every time? – RDFozz Mar 17 '17 at 18:30
  • Yes...that is true. – Feivel Mar 17 '17 at 20:25
  • Did the solution in the link you provided work for a while? And, did it include restarting the server? – RDFozz Mar 17 '17 at 21:08
  • 1
    Your post sounds like the problem stopped after the registry change, then started up again; wondering if a factor other than the registry change was involved 9like a server restart). Not that regular server restarts are an optimal solution, necessarily - but it would indicate more symptoms to consider. – RDFozz Mar 17 '17 at 21:20
  • Yes every time this issue happens I can't really do anything but forced to restart the server. However, this has become a more frequent event these days and I can't really figure out where else to look for. – Feivel Mar 18 '17 at 6:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.