What is the Reporting services log right before the error? You would want to look at a few of the lines before the error, especially the one right before the error.
And when you say:
Nobody changed any of the data sources. All we did was edit the SQL inside of the data driven subscription on the web portal and apply the change.

How did you make this change? Do you mean by editing the SQL in the rdl file itself?

Sue