SSIS Components on http://www.copydynamic.com/

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)

Advertisements
Posted in Uncategorized | Leave a comment

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.

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 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

image

 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.  

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, 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:

ReportExport1

Execute SQL Task – collection of “Parameters” from database

Foreach Loop Container – Loop execution of report for every parameter from Sql Task (trough AdoEnumerator) saved in string variable

Script Task – render report in pdf and save it on local disk

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).

Posted in SSIS | 46 Comments