Hi,
We have an requirement where at realtime we need to generate around 36 files(9 PDF, 9 RTF, 9 HTML and 9 TXT) per session and then convert the file into Binary format and forward it to Application.
We are planning to achieve it through SSRS subscriptions and invoke it from SQL Server.
Through Job id(Subsciption Jobs) from SQL Agent if i am invoking then it is creating the event and then the file is generated which actually works after 1 second and also on concurrent environment i am not sure how to hold the file name.
Since this is highly concurrent environment, Performance is the key.
Please guide me if we should go ahead with this architecture, I am using SQL 2012 Enterprise version.
If yes then what could be the optimum way to achieve it.