Trouble running scheduled SSIS task in SQL Jobs

[Cpreston]

Hi

I have an SSIS package that runs and updates the SQL table no problems.

However when I try and run it from a job in the sql server it keeps failing any ideas please, the log text is below (may be a SQL issue but maybe someone else as had a similar issue) Thanks

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
06/24/2015 16:44:23,importemployee,Error,0,22-F2-ADM-3516,importemployee,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\CPreston. The last step to run was step 1 (Import).,00:00:00,0,0,,,,0
06/24/2015 16:44:23,importemployee,Error,1,22-F2-ADM-3516,importemployee,Import,,Executed as user: 22-F2-ADM-3516\SYSTEM. The package could not be loaded. The step failed.,00:00:00,0,0,,,,0
06/24/2015 16:42:55,importemployee,Error,0,22-F2-ADM-3516,importemployee,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\CPreston. The last step to run was step 1 (Import).,00:00:00,0,0,,,,0
06/24/2015 16:42:55,importemployee,Error,1,22-F2-ADM-3516,importemployee,Import,,Executed as user: 22-F2-ADM-3516\SYSTEM. The package could not be loaded. The step failed.,00:00:00,0,0,,,,0
06/24/2015 16:39:44,importemployee,Error,0,22-F2-ADM-3516,importemployee,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\CPreston. The last step to run was step 1 (Import).,00:00:00,0,0,,,,0
06/24/2015 16:39:44,importemployee,Error,1,22-F2-ADM-3516,importemployee,Import,,Executed as user: 22-F2-ADM-3516\SYSTEM. The package could not be loaded. The step failed.,00:00:00,0,0,,,,0

 

[fredericofonseca]

error is self explainatory - package is not found in whatever location you specified on your step execution - this can be because location is incorrect or the sql server agent user does not have permissions to read it

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Cpreston]

Hi

That is strange. The path is 100% correct. If I run the package from the SSBIDS it runs ok and updates the table in the database. I am logged in as my user name on my computer.

I log into the management studio with the same log in. Not sure where permissions to run from SQL to a directory is given in SQL (if at all).

Any ideas please

Thanks

 

[Cpreston]

well I have tried everything going, using SA, checked all permissions between files etc.... I now have this error log

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
06/25/2015 12:10:57,Step_1,Error,0,22-F2-ADM-3516,Step_1,(Job outcome),,The job failed. The Job was invoked by User IT_SERVICES\CPreston. The last step to run was step 1 (Step_1).,00:00:00,0,0,,,,0
06/25/2015 12:10:57,Step_1,Error,1,22-F2-ADM-3516,Step_1,Step_1,,Executed as user: 22-F2-ADM-3516\SYSTEM. The package could not be loaded. The step failed.,00:00:00,0,0,,,,0

 

[fredericofonseca]

read through the following links.

https://msdn.microsoft.com/en-us/library/ms178142(v=sql.105).aspx

https://www.simple-talk.com/sql/database-administration/setting-up-your-sql-server-agent-correctly/

note that the sql server agent user should always always be a Windows user from the domain (with the exception of local instances on your own pc where it can be the local service one as long as any packages you run do not require access to files outside your pc)


as for permissions to folders - if you don't know ask your network administrator group as they should know (and if not they can go and learn how as it is their work!!). This is the basic of any Windows permissions so not going to explain how it works.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Motlatjo]

Hi

Create a proxy user with the administrator privileges and run the job under the user.