If Thom's solution does not work directly in an ExecuteSQL task, with ? parameters, there is another option.
- Create a 'calculated' variable (a variable whose definition is an...

DROP TABLE IF EXISTS #DodgyData;

CREATE TABLE #DodgyData
(
  Id INT IDENTITY(1, 1)
, Col_A CHAR(1)
, Col_B CHAR(1)
, Col_C CHAR(1)
, Col_D CHAR(1)
);

INSERT #DodgyData
(

Tough one. That error message could be more helpful.

Are any of the packages in the project using post-2012 SSIS features.

Is this cheating?

EXEC sys.xp_cmdshell 'date /t';
EXEC sys.xp_cmdshell 'time /t';


Does the target server version of the SSIS project match the target server?

I assume you've checked disk space on the live server, plus any limits on log file size?