Printing text query results to pdf fails

Buzzy Cheadle 1 Reputation point
2020-09-01T12:44:42.843+00:00

when attempting to print query results (to text) to a pdf it fails with error: Value cannot be null. Parameter name: moniker. What is the fix for this.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2020-09-01T21:51:36.157+00:00

    You mean that when you are in a results grid/window SSMS, you select Print from the context menu and then you select a PDF writer as a the printer?

    It may be an issue with your PDF writer. I tested to this operation from SSMS with CutePDF Writer and it worked fine. On the other hand, I have never been able to get the PDF writer that comes with Windows to work.

    I am not affiliated with CutePDF. As I recall it is free.

    0 comments
  2. Monalv-MSFT 5,891 Reputation points
    2020-09-02T03:30:03.367+00:00

    Hi Buzzy,

    We can also use OLEDB source and Flat File Destination to load data from SQL query results to .txt file.

    Please refer to the following pictures:

    22100-queryresults.png
    22014-oledb-source-sql-command-query-results.png
    22103-df.png

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.