We are building our bill system printing process and part of the process is to generate a huge PDF to a file share with single page bills inside to print on our folding / stuffing appliance. Currently, there is a one
time subscription created on the report server that is then executed from SSIS in the form of a "Execute SQL Server Agent Job Task" which will send a PDF to a file share defined in the subscription.
We are noticing that this process can go wrong at many points and need to find a way to account for each potential problem. We first notice that SSIS is totally unaware of almost all failures of the report subscription
except the most basic failures that the SQL Server agent is aware of like the subscription being faulty or the database being down; we can capture that easily enough; but it isn't sufficient.
SSIS executes the SSRS subscription in seconds even though it might take 45 minutes or longer to render.
After SSIS has called the subscription, we have noticed a few problems can happen.
1. A permissions issue can occur on the file share if your password expires (Failure writing file: A log on error occurred when attemp
View Complete Post