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

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

Download ReportExport2012.zip

(please change name of downloaded file from reportexport2012-zip.doc to reportexport2012.zip).

—————————

Description is here.

Advertisements
This entry was posted in SSIS and tagged , , , . Bookmark the permalink.

One Response to Run and Export SSRS Reports from SSIS (SQL Server 2012)

  1. Fiker says:

    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.

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