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 by schedule 11'. I don't know What is causing the problem
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 by schedule 11'. I don't know What is causing the problem
Comment