this may be a really basic question . . . but I am trying to run an SSIS package as a job. The package won't run and the error message I get on step 1 is:
Executed as user: SERVERNAME\SYSTEM. The package could not be loaded. The step failed.
The job owner is my Windows login on the server, but even if I change the job owner to SYSTEM it won't run.
I'm assuming it is a user credentials problem, is that a correct assumption
Thanks for any help.
Running jobs with SQL Server Agent
Hot Topic
- Generating scripts in SQL 2005
- Reporting services access problem !!!!!!!
- How to copy a assembly from one db to another db with T-SQL ?
- Evaluating String Content
- Move DTS packages from SQL 2000 to SQL 2005
- Errors in the OLAP storage engine:
- Custom Stored procedure
- AS 2005 Business Intelligence Wizard scripts
- Volatile parent key
- RDA problem
SQL Server
- Excel File Locked
- Import/Export data with SQL Server 2005 Express
- Access rights...
- Ignore Null in a Column that otherwise needs a Unique Value
- installing sql
- columns_updated() -- working backwards
- Stupid Replication Q
- Problem in deleting rows in table
- Dynamically using different schema names in Oracle
- Join XML fragment with real table
Running jobs with SQL Server Agent
elvisrs
The account under which SQL Server, Sql Server Integration Service, and SQL Agent are running might be different. If yes, try to make them "same as the job owner" as first attempt. If this works, then you can be sure that it was credential issue and nothing else (like locating the package).
HTH,
Nitesh