Hi,

This issue is now fixed. Thank you for your help.

When I run the job manually, I login using sysadmin and just run the job.

The account that starts SQL Server agent is 'LocalSystem'. I can change the permission...

Hi,

Here is the answer to your questions.

What to Step 1 do? ===> Step 1 runs a SQL Script that copies some data from Informix to SQL Server. ...

Hi,

SQL server start up account is 'system account'. Is that 'sa'? DTS package is owned by MIS-Server/Administrator; Scheduled job is owned by 'sa'

Thanks.