Dear team,
MY name is Sunil Kumar, working in IT company as a .net developer and strong hands on SQL server db engine, SSIS, SSRS. As I understand your problem, it is related to query performance, it can be optimised.i my previous organization we were dealing with large using SSIS pakage service.
I am interested in your product. you can contact me on mudgilsks at Gmail