Hi @Ismail Cassiem ,
- We can set Event Handler OnError Event in ssis package.
- Please view the job history log.
a. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
b. Expand SQL Server Agent, and then expand Jobs.
c. Right-click a job, and then click View History.
d. In the Log File Viewer, view the job history.
e. To update the job history, click Refresh. To view fewer rows, click the Filter button and enter filter parameters.
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.