Another note on this, I tried recreating this in a virtual environment with an image of the instance and replicated the steps as per the MSDN blog, the package worked fine. Therefore I'm guessing that its something on the actual box that's different or that's causing a problem.

Anyway, feel free to contribute any suggestions guys