I have an SSIS package that contains a simple SQL execute the task which contains a simple query :

Update table
set column_name = xyz
where column = 1

I have created a catalog in Management Studio and have deployed the SSIS package in the catalog folder. I started the SQL Server Agent and created a job to schedule the package to execute, but it fails and gives an error. 'The job failed. The job was invoked...