Hi,
A SQL Server, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services(SSAS) expert here.
I would like to have a detailed document of your requirements so that we can discuss the each and every point in details.
Thanks,
Murtaza