Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trouble running scheduled SSIS task in SQL Jobs

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
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
 
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

FAQ219-2884
FAQ181-2886
 
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
 
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
 
read through the following links.



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

FAQ219-2884
FAQ181-2886
 
Hi

Create a proxy user with the administrator privileges and run the job under the user.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top