I just want to make sure that I'm looking at doing this the best way.
Upon a certain condition in an SSIS package, we'll need a report from SSRS to run.
From my research, it seems the easiest way is to create the subscription on the report for a previous date to get the SQL Agent Job and then call that. I don't like that it creates a GUID for the name of the Job and if anyone knows a way around that then groovy.
I'm not keen on doing a script task within the SSIS package.
Does anyone know of other options or ways they've done similar things?