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,702 questions
Developer technologies Transact-SQL
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    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,926 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.