Running sql 2005 SSIS package as a job

[johnv20]

Hi,
I'm currently trying to come to grips with sql 2005 & am having an issue trying to get an SSIS package to run as a job

All the package does is copy a table from one server to the local server
Manually executing the SSIS package works everytime

However running the package as a job causes a failure every time

The only strange thing I can see is that even though I'm setting the job up to log onto the server using sql sa account it keeps defaulting back to windows authentication & is attempting to run as TESTSERVER\system

Does anyone have any ideas

Error message is as follows

08/05/2006 17:44:27
Log Job History (Test SSIS package)

Step ID 1
Server E3DBDPCS04
Job Name Test SSIS package
Step Name step1
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: TESTSERVER\SYSTEM. The package execution failed. The step failed.

 

[johnv20]

forget about it - I didn't have a proxy account setup