Import from Oracle fails when scheduled

[supermatchgame]

I'm trying to import some tables from Oracle to SQL. I start by using the SQL Import wizard to select source (I'm using Oracle Provider for OLE DB) and destination, select tables etc. and then I save the package to SQL Server. I run the job as sa on the SQL server, click finish, the package gets created and the data gets imported. Fine so far.

Next, I want to do this every night, so I set up a new job. I create step 1, put the new package in, then set a schedule and save the job which works ok.

Then I right click on the job and choose 'start at step', and the job fails. I get no specific error message in the history - just 'The package execution failed. The step failed'.

Can anyone tell me what I'm doing wrong?

 

[MDXer]

which user is the job running as?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[supermatchgame]

The message says 'Executed as user SERVERNAME\SYSTEM'

 

[MDXer]

try setting the job to run as SA.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck