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

Question

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.

Answer 1

My context: SQL job executing (using on its step an SQL Server proxy related to an account without administration privileges on the local server) a File System SSIS package located in a remote server, where de SSIS package tries to process an Excel file (.xls).

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

My solution: Granting Full Control privileges on HKEY_USERS.DEFAULT\Software\Microsoft\Office to the account related to the SQL Server proxy.

Answer 2

Found the Solution , It was due to desktop Heap Size