I have an SSIS export package used as a step in a job. The job is called up through a stored procedure. The job completes the first step (gather required data) and then fails 75% or more of the time on the export step. In the app log the failure is listed as event 12291. Package "xxx" failed. The failure email notifications state that the export step was the last step to run.
I would better understand the problem if it failed all the time.. but it just fails most of the time. I'd like it to export the data 100% of the time as this is part of a complex setup I've established so that users can obtain these results.