SSIS Set SQL agent job for child package in 32 bit

Question

I have a parent package "Master.dtsx" containing 3 child packages. Each is executed with "Execute package task".

Master package is set as "32-bit runtime" in SQL Agent Job. However, child packages are not running in 32bit mode. Is there any approach to set child package "32-bit runtime" from Master, or any other work around?

P.S.

1) I'm SURE child pkgs are not in 32 bit because I tried to execute each one separately from "SSISDB" with "32-bit" checked and succeeded. But when executed from Master they failed.

2) I tried with "execute process task" for child packages in Master as this link shows, but it always fails... Also, "Run64BitRuntime" in "Debug Options" for that project is set as "False" in visual studio

3) To set each child package as a single step in SQL agent job and make them to be "32-bit runtime" from there could be the last choice... please provide something more than that, thanks in advance!!

Answer 1

Using execute process task instead of execute package task is the way to do it. The link you've seems to be accurate; but make sure you're entering package path in double quotes. So in the arguments field, enter package path as /file "Your full path.dtsx"

Hope this helps!