I have a data driven subscription and for the file name and path - it comes from a stored procedure. It appears when I test the stored proc in the set up it tests successfully but the when I use the values for the file path and names coming for the stored procedure, it does not work... Fabulous error messages by the way - it just says processed errors in the GUI of SSRS...is there any way to interpret the errors?
If you are passing the correct parameters (Otherwise, the subscription engine would reject them), make sure you are using correct service account to access the path. More often than not these are the two main reasons for the failure. BTW, I would search the log files present at `$DEFAULT_INSTALLATION_PATH\Reporting Services\LogFiles` to find more details about the errors. Generally, it gives the specific information.