Some more information:

I had to put the package in the system database MSDB and then can execute the package in SQL Server Management Studio (pointing to SSIS instead of the DB) - the data is transferred from Oracle to SQL Server. It is only when I try to execute the package in VS2008 that the problem occurs.

Thanks

Adam