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.