I finally solve my own problem luckily without calling Microsoft which would have charged an arm and a leg (It did took a while for me to solve this one!).
I just rebuild the SSIS solution from scratch .
The original SSIS solution was migrated (exported) from another server.
However, the new SSIS solution still uses the old DTSX package from the original solution.
There must be something that I migrated that the box didn't like.
Thanks all who tried to help me solve the problem.