hoping someone can help me out. I have no idea what's going on with this job. It runs every week night and always comes back with the same errors.
There are about ten files that are written. We pull the data from our database then convert them to flat files and send it to a third party vendor. Our third party has reported back that all they can view on the error files are the headlines, but no info.
I ran the job manually in debug mode in ssms and there are absolutely no bugs in the package itself. the job succeeded just fine.
Some background - this job has been running with errors since july, which is around the time they set up a new school year as this job is for an educational setting.