I've got a server agent job scheduled to run every morning. This job contains about 15 steps and one of the steps uses an SSIS package which get data from an iseries database. Occasionally this job fails and I can't tell why. Is there some kind of log recorded that will tell me exactly how far through the job got and why it failed. Many thanks for any help. Stuart.
Hello Stuart, You can also introduce checkpoints in your SSIS package. This will log all the details of the failure. Also, after troubleshooting the job failure. The SSIS package can start processing the data from the point it had failed. Hope you find it helpful. Thanks, Pradeep