Im trying to schedule an SSIS package but I keep on receiving errors when I try to execute.
The error in the job history is: "The package execution failed. The package failed.
But when I run in the in the BI Studio the package works fine
Here are my steps:
1- In the Sql Agent I create a new job.
2- Give the job a name
3- Create a step.
4- Type: IIS Package
5- Package Source: File System
6- Set Schedule
When I try to run manually I get an error.
Am I missng a step?