my project team is looking to automatically print food orders from SSIS ...

Question

and it does not provide a method to print (it create for data migration, data transformation, and integrations). Is it possible to send the PDF files to be printed in an automated fashion, as the team was unable to find any APIs for PaperCut that would create an automated print job from a file.

Answer 1

@Cindy Chapman

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.

Answer 2

Hi @Cindy Chapman , I work at PaperCut and we don't generate content, we will print PDFs your application can output. I am not familiar with the application you want to create content from.