You are correct here when it is a simple case of just getting the data and emailing the report SSRS works but there are jobs for which I have to do multiple steps like select data ,update table ,copy data and then generate reports so for such cases I will need SSIS reports.

Thanks