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

Cindy Chapman 0 Reputation points

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.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
460 questions
Windows Server Printing
Windows Server Printing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Printing: Printer centralized deployment and management, scan and fax resources management, and document services
613 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ryan Hill 22,911 Reputation points Microsoft Employee

    @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.

    0 comments No comments

  2. Alan Morris 1,041 Reputation points

    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.

    0 comments No comments