The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter how many times we told them otherwise. I even told them they needed to put comments in their code so everyone could understand later, but usually the comments ended up being along the lines of the stored proc name with "select" or "insert" added.

So, yeah, we inherited a mess. I was going to try and assist the Devs in rebuilding the package, but I'm clueless on how this thing is working. So I guess I'm going to leave it to them to fix.