It is possible to use the destination output of a Package in SSIS as the input source of a report in Reporting Services. In SSIS the package can send output to a datareader destination object, this in memory output can then be captured by Reporting Services.
Configuring Reporting Services to Use SSIS Package Data
There is an article on MSDN that describes the configuration and also warns about possible security risks.
Creating Report Datasets from SQL Server Integration Services
The follow-up article on MSDN explains how to create a package and a report