Ok a quick update. Thanks for everyones help

Scheduling the package was a bit of a mess.

Firstly according to video I needed a Proxy. (Never heard of one)...

Thanks for that ..but i get the error even before i include the package in a schedule job

Just clicking on the package in the SSIS engine, which runs it under...

Ok. After 2 days i have figured out why this has caused me and many others out there such a problem.

The "xml source" control can only read xml files that...

I have worked out the problem

The DBA administrator didn't like Reporting services giving the SQL scheduled jobs in SQL Enterprise Manager these long meaningliess numbers.

So he set up a job...