Package “Run and Export SSRS Reports from SSIS (SQL Server 2008)” with export to excel and pdf.
Download ReportExport2008.zip (delete .doc).
Recent Comments
Enrique O on Run and Export SSRS Reports fr… raviraja on Run and Export SSRS Reports fr… Fiker on Run and Export SSRS Reports fr… Fiker on Run and Export SSRS Reports fr… Zoran Ivić on Run and Export SSRS Reports fr…
:: BI Blog Tryout :: 
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
Hi,
Please delete .doc and change -zip to .zip
File name should look like this: reportexport2008.zip
Best regards,
Zoran
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.
thx for feedback (sorry for late replay)
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.
Ignore my Aug 28, 2012 issue – I left out “?” on after reportserver. This great code! Thank you for posting.
Awesome. I spent days trying to figure this out. Thankyou very much
Thankyou very much