Post reply

Reports within SQL 2005 Integration Services

  • March 12, 2009 at 7:05 pm

    #958869

    I am getting a corrupted PDF. I am running on Windows Server 2008 65 bit server and SQL Server 2008 and wonder if this may have something to do with 64 bit processing. I sounds like it works for others.

  • March 13, 2009 at 10:37 am

    #959295

    64 bit should work, it is what I am using, although I am not using MSSQL 2008. Try rendering the pdf from the report server using the url syntax

    http:// &rs:Format=PDF&rs:Command=Render

    this is essentially what the code is doing via SSIS. When I originally created this I received some corrupt PDFs due to incorrect syntax in the scripts. Let me know if that helps.

  • March 13, 2009 at 10:46 am

    #959305

    Hey Patrick Kelly,

    Thanks for the feedback. I keep getting a corrupted PDF file. Not sure why.

    My workaround is to schedule a job in Reporting Services, that creates the PDF report and saves it in a file share. Then I have an SSIS package, pick it up, copy to an archive directory and give the report a name with a time stamp. It's not ellegant but it works for now.

  • March 10, 2011 at 2:47 pm

    #1297382

    Yes, Hello I'm interested in this type of solution. I want to send our reports after a SSIS job completes... please provide your solution... thanks

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply