Run and Export SSRS Reports from SSIS (SQL Server 2008)

Package “Run and Export SSRS Reports from SSIS (SQL Server 2008)” with export to excel and pdf.

Download ReportExport2008.zip (delete .doc).

Description is here.

 

Advertisements
This entry was posted in SSIS. Bookmark the permalink.

8 Responses to Run and Export SSRS Reports from SSIS (SQL Server 2008)

  1. Hi Zoran, you mentioned to delete the .doc extension…do you mean to rename it? if rename then what should it be renamed to?

    Thanks

    PJ

  2. Lynn says:

    I’m getting warning when opening the pdf/excel and file size is 0…I changed the report and package to our sql server name. It ran successful but both pdf and excel are zero in size and when you try to open it here is the msg for excel: “The file you are trying to open,’Parameter 1 20120828.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted andis from a trusted source before opening the file. Do you want to open the file now?” I click “yes”, file open up with nothing in it. When I tried to open pdf it said “Acrobat could not open ‘Parametr 1 20120828.pdf’ because it is either not a supported file type or becaue the file has been damaged (for example, it was sent as an email attachment and wasn’t correctly decoded). To create an Adobe PDF document, go to the source application. Then print the document to Adobe PDF”. I’m running SQL 2008 standard edition.

    • Zoran Ivić says:

      thx for feedback (sorry for late replay)

      • Fiker says:

        I am having the same issue as Lynn. Did you solve this?
        I’m getting warning when opening the pdf/excel and file size is 0…I changed the report and package to our sql server name. It ran successful but both pdf and excel are zero in size and when you try to open it here is the msg for excel: “The file you are trying to open,’Parameter 1 20120828.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted andis from a trusted source before opening the file. Do you want to open the file now?” I click “yes”, file open up with nothing in it. When I tried to open pdf it said “Acrobat could not open ‘Parametr 1 20120828.pdf’ because it is either not a supported file type or becaue the file has been damaged (for example, it was sent as an email attachment and wasn’t correctly decoded). To create an Adobe PDF document, go to the source application. Then print the document to Adobe PDF”. I’m running SQL 2008 standard edition.

  3. Lynn says:

    Ignore my Aug 28, 2012 issue – I left out “?” on after reportserver. This great code! Thank you for posting.

  4. Gus says:

    Awesome. I spent days trying to figure this out. Thankyou very much

  5. Amine says:

    Thankyou very much

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s