When
you try to execute the job, The job will fail with error "Unable to open
Step output file. The step failed"
In this case there is no error with
the package. So we have to change the path in jobs under sql agent job.
For example if the job name is:
Batch_price.
Here is the steps:
1. Double click on Batch_price in sql
agent job. [i.e. job properties]
2. Go to steps.
3. Edit steps.
4.Click advanced option.
5.Change the path under output file as
in image below or delete the path.
6. ok and run the job again.
