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
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