Category Archives: SSIS

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

Posted in SSIS | Tagged , , , | 1 Comment

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

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). Description is here.

Posted in SSIS | 7 Comments

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.  

Posted in SSIS | 8 Comments

Data Flow Task – Excel Destination

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 … Continue reading

Posted in SSIS | Leave a comment

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

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, … Continue reading

Posted in SSIS | 46 Comments