Share via

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,591 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,656 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 112.7K 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,901 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.