I don't believe your question is related to Azure Automation, so I've removed that tag. For your original ask, how to automate your process, it depends on your environment. If you 're looking for ideas/suggestions, you could have your SSIS generate the data into an excel worksheet or flat file.
SSIS doesn't support PDF export natively, but you could attempt utilize scripting to use .NET assemblies to generate the PDF for you based on either the output of the transform or the file your SSIS package generates.
If you go the flat-file route, you can leverage Power Automate cloud or desktop flow to pick up this file, create the PDF, and email that report. I'm not familiar with PaperCut, but if that third-party offering has API support, then you can leverage that API inside Power Automate through the HTTP Connector.