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

  aceoledb, sql-agent-job, sql-server, ssis, windows

Hi 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

Source: Windows Questions

LEAVE A COMMENT