SSRS loop through inside SSIS [modified]
-
I would like to loop through a SQL Server table that contains the paths to all the reports(SSRS) we need to run and then execute the reports via SSIS. What task should I be doing to do this? Will the For Loop work for something like this? Please Explain in Detail if possible Or either Explain me how to run a Report from SSIS -- modified at 1:24 Tuesday 15th May, 2007
-
I would like to loop through a SQL Server table that contains the paths to all the reports(SSRS) we need to run and then execute the reports via SSIS. What task should I be doing to do this? Will the For Loop work for something like this? Please Explain in Detail if possible Or either Explain me how to run a Report from SSIS -- modified at 1:24 Tuesday 15th May, 2007
Why do you need to do something like this?
-
Why do you need to do something like this?
I need to execute a set of reports from SSRS and send it to a list of mail-Id's . This reports will be attachments of the mail (All reports will be send as one attachment) . This need to be scheduled and should be done every day after another package is run by the Sql Job Agent
-
I need to execute a set of reports from SSRS and send it to a list of mail-Id's . This reports will be attachments of the mail (All reports will be send as one attachment) . This need to be scheduled and should be done every day after another package is run by the Sql Job Agent
You will have to synchronize everything manually, but you could create a scheduled subscription for every report and choose Windows File Share as a delivery method. Then, after all the reports are processed, you can get the files from the share and e-mail them. I know it's not an answer to your question, but that's the solution that comes to my mind.
-
You will have to synchronize everything manually, but you could create a scheduled subscription for every report and choose Windows File Share as a delivery method. Then, after all the reports are processed, you can get the files from the share and e-mail them. I know it's not an answer to your question, but that's the solution that comes to my mind.
Thank You , Even i thought about this but it will take a lot of time since we have aroung 300 clients and we need to set different reports and subscription for each client . Most of the reports are client based so we have to give the Client no as one of the parameters And it will take a lot of time any way Thank you for ur help , If you have any solution come in ur mind please let me know Thanks in Advance