Hi,
May be something had simialr issue and know the solution.
SQL job fails with error:
OLE DB provider "MSDASQL" for linked server "ScratchPrimary" returned message "Parameter type cannot be determined for at least one variant parameter.". [SQLSTATE 01000] (Message 7412) Could not execute procedure 'sp_executesql' on remote server
Thank you!