The only thing left for me to believe is the possibility of a bug(s) in the system.

It is not making sense why the history is written out when SSIS package is run but not TSQL statement in scheduled / non-scheduled task / job.

And, I have performed all the possible checks and inspections as what I have known and the ones shared here in the forum.

Appreciate all for taking a look at the situation.

thx again

:cool::-)