I've a SSIS package, which will run daily once at night 2:30 am. I schedule this package in SQL Server Agent job.It will push the data from one source to sql table. Coming to the qv I developed the reports based on this sql table only. Now I want to schedule the qvw file in qv server after running SSIS package successfully.
It's a while since I did this, but the easiest way is to add a new task at the end in the SSIS package (Execute Task, I think) which just needs the command line so it will be path to your .qvw with a /r switch.
