0

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.

Dale K
  • 25,246
  • 15
  • 42
  • 71
Vlogs Bengali
  • 85
  • 1
  • 13
  • First thing to check is that Microsoft.ACE.OLEDB 12.0 is installed and well registered in the machine where your package is now running. Other thing to check is that the same version of ACE and Excel you are using in your dev machine are being used in the new machine. – Jayvee Apr 13 '21 at 08:31
  • I am using ACE OLEDB 16.0 both in dev and prod. – Vlogs Bengali Apr 13 '21 at 09:00
  • For Ace OLEDB 12.0 in prod - The step did not generate any output. The return value was unknown. The process exit code was -529697949. For Ace OLEDB 16.0 error is - The process exit code was -1066598274. – Vlogs Bengali Apr 13 '21 at 09:01
  • the error for ACE 16 seems related to 64b incompatibility, could be that dev SQL server is running in 64b and prod in 32b. A workaround you could also try is downgrade the excel version, i.e. from xlsx to xls – Jayvee Apr 13 '21 at 09:21

1 Answers1

1

Found the Solution , It was due to desktop Heap Size

Vlogs Bengali
  • 85
  • 1
  • 13