All downloads are available at http://www.copydynamic.com under sections Free code or Tasks (free code or tasks for 2012, 2014/2016 servers).
There are also 2 new SSIS tasks:
– Report Export (Select Report with parmaters, select export folder and (or) printer and make fast export with no coding)
“Comming soon” – Copy Dynamic (Reverse engineering of Oracle, Informix, Postgres and MySql scheme/database with great debugging options)
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.
Package “Run and Export SSRS Reports from SSIS (SQL Server 2014)” with export to excel and pdf.
Download Report Export 2014
(please change name of downloaded file from reportexport2014-zip.doc to reportexport2014.zip).
Package “Run and Export SSRS Reports from SSIS (SQL Server 2008)” with export to excel and pdf.
Download ReportExport2008.zip (delete .doc).
Why export data data in excel? Because User wants it in excel. Sometimes I asked myself is there any reason for my work except “satisfying” Users want for excel sheets. From “A1” to final destination ∞. Also, all these sheets should be formatted on right way.
Microsoft didn’t make enough properties for “so loved” Excel Destination in Dataflow Task and I decided to make formatting it on this way:
– create template excel file (saved far away from Users) with Headings and “dummy” row with cell formats
– copy file to desired location and export data into it
Data Flow to Excel Destination will take the format of last used row for every new row. So, data in W3 cell will be italic with percentage format.
Few days before I finished SSIS package which produces lot of Excel sheets for regular use in company where I work. I am not so sure how much is useful to have sheet with 20 or 30 thousands rows (yes, that’s for regular work), but I made a tool and Server takes care about populating Excels.
So, customers are almost happy, but… as an addition to excels I had to made Summaries for every excel. I decide to made SSRS report with one parameter and run it trough SSIS and export it like PDF file in same folder where Excels are. Unfortunately, wasn’t so easy to find simple solution and that is reason for this post…
Picture of simplified solution:
Script task needs Credentials for HttpWebRequest class. I’m using default, but it can be changed in SSIS configuration file.
Example package can be downloaded here ReportExport.zip – delete .doc extension (SSIS and SSRS project with sample report).
 | 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 :: 