sql-serverwindowsssissql-agent-jobaceoledb

SSIS job failing with error “The step did not generate any output. The return value was unknown. The process exit code was -529697949. ”

I have a SSIS Package which has a simple dataflow with Excel to Excel data transfer. I am using Microsoft.ACE.OLEDB 12.0 driver for connection. Now in my development machine it is running fine through packages. But when I deploy and ran it via SQl agent job it is giving me the error

The step did not generate any output. The return value was unknown. The process exit code was -529697949.

I tried enable the logging and but its not printing any error in the logs.

Kindly suggest.

Solution

  • Found the Solution , It was due to desktop Heap Size