Running a SSIS package as a job in SQL server management studio

141 Views Asked by At

I have a SSIS package which has a Script task in it with no errors.

When I run the package in my local it is running without any errors, but when I deploy the package and schedule it as a job, both ways it is giving failure message and giving this error on the script task Error:

The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully

This is happening when the package is manually ran or ran as a job.

Note: I have recreated the script task again multiple times and rebuild the solution again without errors.

0

There are 0 best solutions below