February 12, 2021 at 11:34 am
Hello,
I have a client who has a letter run that is produced monthly using a combination of SSIS and SSRS. In short, a foreach loop passes the parameter intothe ssrs report and usinga C# script task generates a PDF into a windows folder.
They are asking if I can alter the process so that instead of generating mutiple PDF files, it generates 1 large PDF file with all the letters in it.
I have thought about adding a Powershell script to the end of the SSIS job to stich the files together but I am trying to find if there a cleaner way to do it. Does anyone have any ideas please?
Cheers,
Dave
February 12, 2021 at 12:04 pm
Bolting them all together at the end sounds clean enough to me – also makes it easier to maintain when things change (adding or removing files, changing file order etc)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 12, 2021 at 12:58 pm
If you change the SSRS report to create one page for each customer (with a page break in-between), you should be able to execute that report in the same way you do now (without a customer as parameter) and achieve what you need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply