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::-)
Cheers,
John Esraelo