{"id":4008,"date":"2018-06-16T20:07:59","date_gmt":"2018-06-16T20:07:59","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4008"},"modified":"2018-06-22T15:23:45","modified_gmt":"2018-06-22T15:23:45","slug":"calling-ssrs-reports-in-ssis-export-emai","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/","title":{"rendered":"Calling SSRS Reports in SSIS (Export \/ Email)"},"content":{"rendered":"<h2>Introduction about calling SSRS Reports in SSIS<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-4022 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\" alt=\"Logo of Reporting Services\" width=\"93\" height=\"93\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png 260w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo-150x150.png 150w\" sizes=\"(max-width: 93px) 100vw, 93px\" \/><\/a>Calling SSRS Reports in SSIS is straightforward using the ZappySys Reporting Services task. Also, we will show how to export files SSRS files using SSIS, how\u00a0to send reports in emails and how to send parameters.<\/p>\n<p>In addition, we will be using this\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a>\u00a0component to make things work:<br \/>\n<div class=\"su-table su-table-alternate\">\n<table width=\"300\">\n<tbody>\n<tr style=\"line-height: 0px\">\n<td width=\"50px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-report-generator-task\/\" target=\"_blank\" rel=\"noopener\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/zappysys.com\/images\/SSIS-PowerPack\/SSIS-SSRS-Reporting-Services-Task.png\" alt=\"SSIS Report Generator Task (Export SSRS Reports) \" width=\"50\" height=\"50\" \/><\/a><\/td>\n<td style=\"vertical-align: middle\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-report-generator-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Report Generator Task (Export SSRS Reports)<br \/>\n<\/a><\/td>\n<\/tr>\n<tr style=\"line-height: 0px\">\n<td style=\"height: 58px\" width=\"50px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-file-system-task-advanced\/\" target=\"_blank\" rel=\"noopener\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3074\" src=\"https:\/\/zappysys.com\/images\/SSIS-PowerPack\/ssis-file-system-task-advanced.png\" alt=\"Advanced SSIS File System Task\" width=\"50\" height=\"50\" \/><\/a><\/td>\n<td style=\"vertical-align: middle;height: 58px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-file-system-task-advanced\/\" target=\"_blank\" rel=\"noopener\">Advanced SSIS File System Task<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>In order to understand the functionality, the following video tutorial can be useful to understand the functionality of this useful Reporting Services task:<br \/>\n[youtube https:\/\/www.youtube.com\/watch?v=ajnSgbXls7I&amp;w=560&amp;h=315]\n<h2>Requirements<\/h2>\n<ol>\n<li>First of all, we will need ZappySys SSIS PowerPack. This tool contains the Reporting Services Task.<\/li>\n<li>Secondly, you will require SSDT for Business Intelligence to create SSIS projects.<\/li>\n<li>Also, make sure to have an SSRS report deployed. For more information<br \/>\nabout creating reports and deploying, refer to these links:<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/create-a-basic-table-report-ssrs-tutorial?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\">Create a Basic Table Report (SSRS Tutorial)<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/reports\/publishing-reports-to-a-report-server?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\">Publishing Reports to a Report Server<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Getting started<\/h2>\n<p>We will first show how to export an SSRS Report to Word format (docx). Also, the ZappySys SSIS PowerPack, allows converting\u00a0your SSRS reports deployed into Word (docx and doc), Excel (xlsx and xls), PDF, TIFF, CSV and XML.<\/p>\n<h3>Calling SSRS Reports in SSIS<\/h3>\n<ol>\n<li>First of all drag and drop the ZS Reporting Task that is included with\u00a0our ZappySys SSIS PowerPack:\n<div id=\"attachment_4025\" style=\"width: 624px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Reporting-Service-task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4025\" class=\"size-full wp-image-4025\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Reporting-Service-task.png\" alt=\"Task to convert SSRS report into files\" width=\"614\" height=\"433\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Reporting-Service-task.png 614w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Reporting-Service-task-300x212.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/a><p id=\"caption-attachment-4025\" class=\"wp-caption-text\">SSRS task in SSIS<\/p><\/div><\/li>\n<li>Secondly, in general tab, make sure that the Export server report is\u00a0enabled.<\/li>\n<li>Additionally, specify the report service URL. If you are not sure what is your report\u00a0service URL, check the step 3 in requirements.<\/li>\n<li>In addition, in report path, select the report that you want to export\u00a0to a file.<\/li>\n<li>Also, check the output as a file option:\n<div id=\"attachment_4026\" style=\"width: 635px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-export-report-to-file.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4026\" class=\"size-full wp-image-4026\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-export-report-to-file.png\" alt=\"Configurations to export files\" width=\"625\" height=\"602\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-export-report-to-file.png 625w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-export-report-to-file-300x289.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-4026\" class=\"wp-caption-text\">Export report to file<\/p><\/div><\/li>\n<li>Additionally, in the export settings tab, go to Save as and specify the path and\u00a0extension of the file to export. You can export to Excel, Word, PDF, Tiff,\u00a0CSV and XML:\n<div id=\"attachment_4042\" style=\"width: 636px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-export-report-server-PDF-DOCX-XLSX.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4042\" class=\"size-full wp-image-4042\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-export-report-server-PDF-DOCX-XLSX.png\" alt=\"Reporting Services to Excel Word PDF\" width=\"626\" height=\"615\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-export-report-server-PDF-DOCX-XLSX.png 626w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-export-report-server-PDF-DOCX-XLSX-300x295.png 300w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/a><p id=\"caption-attachment-4042\" class=\"wp-caption-text\">Export SSRS report using SSIS to Excel, Word, PDF<\/p><\/div><\/li>\n<li>Finally, run the package and the file will be created:\n<div id=\"attachment_4044\" style=\"width: 373px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-report-in-word.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4044\" class=\"size-full wp-image-4044\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-report-in-word.png\" alt=\"Calling SSRS Reports in SSIS to export to MS Word \" width=\"363\" height=\"225\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-report-in-word.png 363w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-report-in-word-300x186.png 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><p id=\"caption-attachment-4044\" class=\"wp-caption-text\">SSRS report exported to docx<\/p><\/div><\/li>\n<\/ol>\n<h3>Changing the names of the reports with the date format<\/h3>\n<p>In order to explain how to add the prefix or suffix of a file with the\u00a0current date. For example, I want my SSRS reports with this format:<br \/>\nFilename20180323.xlsx where 20180323 means march 23, 2018. To understand how to do it, In this new example,\u00a0we will show how to do it.<\/p>\n<ol>\n<li>First of all, we will use the ZappySys Advanced File System Task:<\/li>\n<li>Secondly, we will use the option Rename files and rename using the fun_getdate\u00a0function like this: <strong><strong><strong>Filename&lt;&lt;yyyy-MM-dd,FUN_GETDATE&gt;&gt;.xlsx<\/strong><\/strong><\/strong>\n<div id=\"attachment_4051\" style=\"width: 693px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-rename-a-file-with-current-date.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4051\" class=\"size-full wp-image-4051\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-rename-a-file-with-current-date.png\" alt=\"SSIS Rename files with date\" width=\"683\" height=\"633\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-rename-a-file-with-current-date.png 683w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-rename-a-file-with-current-date-300x278.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><p id=\"caption-attachment-4051\" class=\"wp-caption-text\">Rename the file with a\u00a0date in SSIS<\/p><\/div><\/li>\n<li>Also, you can watch all the available examples of functions by pressing the\u00a0Expressions (x) button:\n<div id=\"attachment_4057\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-functions-for-dates.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4057\" class=\"size-full wp-image-4057\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-functions-for-dates.png\" alt=\"Functions in SSIS \" width=\"680\" height=\"629\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-functions-for-dates.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-functions-for-dates-300x278.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-4057\" class=\"wp-caption-text\">Special SSIS functions<\/p><\/div><\/li>\n<li>Finally, press insert variable and function examples and you will be able to see\u00a0all the examples of special functions to simplify your life:\n<div id=\"attachment_4058\" style=\"width: 916px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-function-examples-for-dates.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4058\" class=\"size-full wp-image-4058\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-function-examples-for-dates.png\" alt=\"Special functions\" width=\"906\" height=\"732\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-function-examples-for-dates.png 906w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-function-examples-for-dates-300x242.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-function-examples-for-dates-768x621.png 768w\" sizes=\"(max-width: 906px) 100vw, 906px\" \/><\/a><p id=\"caption-attachment-4058\" class=\"wp-caption-text\">Samples of functions<\/p><\/div><\/li>\n<\/ol>\n<h3>Moving your report files to a UNC path<\/h3>\n<p>Once that you have your files exported from reporting services to a file,\u00a0you can move, copy them to another path. In this example, we will show how to\u00a0move files to a Shared folder using a UNC path.<\/p>\n<ol>\n<li>\u00a0First of all, specify your file name to move. You can use *.xml\u00a0for example to move all the files.<\/li>\n<li>Secondly, specify the UNC path in destination:\n<div id=\"attachment_4059\" style=\"width: 693px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-move-files.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4059\" class=\"size-full wp-image-4059\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-move-files.png\" alt=\"Move SSRS reports exported to UNC path\" width=\"683\" height=\"633\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-move-files.png 683w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-move-files-300x278.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><p id=\"caption-attachment-4059\" class=\"wp-caption-text\">SSIS move files to UNC path<\/p><\/div><\/li>\n<li>Also, It is possible to sort files by name, size, modified date or other\u00a0properties:\n<div id=\"attachment_4061\" style=\"width: 693px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-move-files-sorted-by-name-modified-date.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4061\" class=\"size-full wp-image-4061\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-move-files-sorted-by-name-modified-date.png\" alt=\"SSIS Sorting files by properties\" width=\"683\" height=\"633\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-move-files-sorted-by-name-modified-date.png 683w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-move-files-sorted-by-name-modified-date-300x278.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><p id=\"caption-attachment-4061\" class=\"wp-caption-text\">Sort file in SSIS by name, size, modified date<\/p><\/div><\/li>\n<li>Finally, press the Examples link, you can see some custom queries that you\u00a0can create:\n<div id=\"attachment_4062\" style=\"width: 572px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-filter-file-properties.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4062\" class=\"size-full wp-image-4062\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-filter-file-properties.png\" alt=\"SSIS queries to get file information\" width=\"562\" height=\"397\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-filter-file-properties.png 562w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-filter-file-properties-300x212.png 300w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/a><p id=\"caption-attachment-4062\" class=\"wp-caption-text\">Sample SSIS queries to files<\/p><\/div><\/li>\n<\/ol>\n<h3>Sending SSRS Report as an attachment in an email<\/h3>\n<p>The task also allows calling SSRS reports in SSIS and send the reports to an\u00a0email. To do it, it is necessary to have an SMTP Server. Let&#8217;s take a look at the\u00a0steps:<\/p>\n<ol>\n<li>First of all, in the general tab, check the email report file and\u00a0uncheck the Output as file option:\n<div id=\"attachment_4064\" style=\"width: 637px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-email-SSRS-Reporting-Service.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4064\" class=\"size-full wp-image-4064\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-email-SSRS-Reporting-Service.png\" alt=\"Send SSRS report as attachment in SSIS\" width=\"627\" height=\"616\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-email-SSRS-Reporting-Service.png 627w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-email-SSRS-Reporting-Service-300x295.png 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><p id=\"caption-attachment-4064\" class=\"wp-caption-text\">Output SSRS report in SSIS as attachment<\/p><\/div><\/li>\n<li>Also, in Email setting tab, press New in SMTP connections to create a\u00a0new connection. You will need to provide an SMTP server name, an email and a\u00a0password. It is also necessary\u00a0to enter the port. You can find the list of some SMTP\u00a0servers and\u00a0ports <a href=\"https:\/\/www.arclab.com\/en\/kb\/email\/list-of-smtp-and-pop3-servers-mailserver-list.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/li>\n<li>In addition, you have an option to specify the sender, receiver, subject, and body. It is possible to write the body in HTML format. You can also\u00a0specify SSIS variables. The following HTML code shows how to write in bold,<br \/>\nitalic, with bullets and more:<\/p>\n<pre class=\"lang:xhtml decode:true\">&lt;h1&gt;This is an example using headers&lt;\/h1&gt;\r\n&lt;p&gt;&lt;strong&gt;This is an example to write using bold&lt;\/strong&gt; &lt;strong&gt;&lt;br \/&gt;\r\n&lt;\/strong&gt;&lt;em&gt;This is an example to write using italic &lt;br \/&gt;&lt;\/em&gt;\r\nThis is an example using underline&lt;br \/&gt;&lt;br \/&gt;\r\n&lt;\/p&gt;\r\n&lt;ol&gt;\r\n  &lt;li&gt;This is an example with lists&lt;\/li&gt;\r\n  &lt;li&gt;Sedond of the list&lt;\/li&gt;\r\n  &lt;li&gt;Third of the list&lt;\/li&gt;\r\n&lt;\/ol&gt;\r\n&lt;ul style=\"list-style-type:circle\"&gt;\r\n  &lt;li&gt;This is an example with bullets&lt;\/li&gt;\r\n  &lt;li&gt;Bullet sample &lt;\/li&gt;\r\n  &lt;li&gt;Working with bullets&lt;\/li&gt;\r\n&lt;\/ul&gt;\r\n<\/pre>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4075\" style=\"width: 635px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-send-report-as-email-attachment.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4075\" class=\"size-full wp-image-4075\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-send-report-as-email-attachment.png\" alt=\"SSIS HTML mail message\" width=\"625\" height=\"665\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-send-report-as-email-attachment.png 625w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-send-report-as-email-attachment-282x300.png 282w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-4075\" class=\"wp-caption-text\">Dynamic HTML in SSIS<\/p><\/div><\/li>\n<li>Additionally, in Visual Studio go to the menu and SSIS, Variables and create two\u00a0variables that will be used in the report named Title and ReportName of type\u00a0string and specify values for them:\n<div id=\"attachment_4066\" style=\"width: 727px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-variables.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4066\" class=\"size-full wp-image-4066\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-variables.png\" alt=\"SSIS dynamic emails\" width=\"717\" height=\"142\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-variables.png 717w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-variables-300x59.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/a><p id=\"caption-attachment-4066\" class=\"wp-caption-text\">Using SSIS variables in emails<\/p><\/div><\/li>\n<li>Finally, run the script and check your email received:\n<div id=\"attachment_4077\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-SSIS-email-sent.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4077\" class=\"size-full wp-image-4077\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-SSIS-email-sent.png\" alt=\"The email with the SSRS Report\" width=\"600\" height=\"358\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-SSIS-email-sent.png 600w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-SSIS-email-sent-300x179.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><p id=\"caption-attachment-4077\" class=\"wp-caption-text\">Email received SSIS Html format<\/p><\/div><\/li>\n<\/ol>\n<h3>Calling SSRS Reports in SSIS with parameters<\/h3>\n<p>Another key point is the use of parameters. Sometimes your SSRS includes parameters. With our Reporting Service Task, it\u00a0is possible to call an SSRS report and pass SSIS parameters. You will require a\u00a0Report with a parameter to test it. If you do not know how to create a parameter\u00a0in SSRS, click <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/report-design\/report-parameters-report-builder-and-report-designer?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<ol>\n<li>First of all, you will need an SSRS Report with a parameter:\n<div id=\"attachment_4081\" style=\"width: 811px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-parameter.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4081\" class=\"size-full wp-image-4081\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-parameter.png\" alt=\"SSRS reporting with parameters\" width=\"801\" height=\"392\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-parameter.png 801w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-parameter-300x147.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-parameter-768x376.png 768w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/a><p id=\"caption-attachment-4081\" class=\"wp-caption-text\">Reporting Service Parameter<\/p><\/div><\/li>\n<li>Secondly, in SSDT or Visual Studio, in the menu, go to SSIS and\u00a0variables. Create an SSIS variable:\n<div id=\"attachment_4082\" style=\"width: 605px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-parameters.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4082\" class=\"size-full wp-image-4082\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-parameters.png\" alt=\"Creating variables in SSIS\" width=\"595\" height=\"109\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-parameters.png 595w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-parameters-300x55.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/a><p id=\"caption-attachment-4082\" class=\"wp-caption-text\">Variables in SSIS<\/p><\/div><\/li>\n<li>\u00a0Finally, in Report Services Task in Visual Studio, go to Report\u00a0Parameters and map the SSRS parameter with the SSIS variable:\n<div id=\"attachment_4083\" style=\"width: 726px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-map-reporting-service-parameters-with-integration-services-parameters.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4083\" class=\"size-full wp-image-4083\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-map-reporting-service-parameters-with-integration-services-parameters.png\" alt=\"SSIS mapping of SSRS paremeters and SSIS variables\" width=\"716\" height=\"497\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-map-reporting-service-parameters-with-integration-services-parameters.png 716w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-SSRS-map-reporting-service-parameters-with-integration-services-parameters-300x208.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/a><p id=\"caption-attachment-4083\" class=\"wp-caption-text\">Map SSIS variable with SSRS parameters<\/p><\/div><\/li>\n<\/ol>\n<h3>Calling SSRS Reports in SSIS using data-driven configuration<\/h3>\n<p>Data-driven configuration allows configuring different reports with\u00a0different configurations. In addition, the option allows handling multiple reports using a\u00a0table with all the configurations for each report. Also, this task creates a table\u00a0in SQL Server with the configurations for each report. Let&#8217;s take a look to see\u00a0how this works.<\/p>\n<ol>\n<li>First of all, select the data-driving report export using config table.<\/li>\n<li>\u00a0Also, you will need to specify the connection to the SQL Server<br \/>\ndatabase.<\/li>\n<li>In addition, go to config table, press new to create a new table:\n<div id=\"attachment_4099\" style=\"width: 632px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-data-driven-SSRS-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4099\" class=\"size-full wp-image-4099\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-data-driven-SSRS-1.png\" alt=\"Data-driven configuration for SSRS in SSIS\" width=\"622\" height=\"618\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-data-driven-SSRS-1.png 622w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-data-driven-SSRS-1-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-data-driven-SSRS-1-300x298.png 300w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/a><p id=\"caption-attachment-4099\" class=\"wp-caption-text\">SSRS Data-driven in SSIS<\/p><\/div><\/li>\n<li>Additionally, ZappySys allows creating a sample table that can help you to understand\u00a0how to configure local reports, Calling SSRS Reports in SSIS and save to files, specify paths, ports, email options and more:\n<pre class=\"lang:tsql decode:true \">CREATE TABLE [{{SchemaName}}].[{{TableName}}](\r\n\tId int identity(1,1) NOT NULL  PRIMARY KEY, \r\n\tGroupName varchar(100) NULL,  \/* Used to filter reports *\/\r\n\tReportType varchar(10) NOT NULL, \/*Local or Server*\/\r\n\tReportServiceUrl  varchar(500) null, \r\n\tReportPath varchar(500) NOT NULL, \r\n\tIsEnabled bit NOT NULL default(1),\r\n\tExportAsFile bit NOT NULL default(1),\r\n\tExportAsEmail bit NOT NULL default(0),\r\n\tParameters varchar(max) NULL, \/* ParameterName1;IsMultiValue;Value1|....ParameterNameN;IsMultiValue;ValueN *\/\r\n\tExportPath varchar(500) NULL,\r\n\tAddFileSuffix bit NULL,\r\n\tExportFileSuffix varchar(500) NULL, \/* e.g. _ddMMyyyy, _ddMMyyyyhhmmss, _ddMMyyyyhhmmss.fff (see this URL http:\/\/msdn.microsoft.com\/en-us\/library\/az4se3k1(v=vs.110).aspx) *\/\r\n\tDescription varchar(500) NULL,\r\n\tEmailFrom varchar(255) NULL,\r\n\tEmailTo varchar(1000) NULL,\r\n\tEmailCc varchar(1000) NULL,\r\n\tEmailBcc varchar(1000) NULL,\r\n\tEmailSubject varchar(500) NULL,\t\r\n\tEmailIsHtml bit NULL default(1),\t\r\n\tEmailBodyText varchar(max) NULL,\r\n\tEmailAttachmentFile varchar(500) NULL, \/*Unused: For future use only*\/\r\n\tLastExportStartDate datetime NULL,\r\n\tLastExportEndDate datetime NULL,\r\n\tLastStatus varchar(20) NULL,\r\n\tLastMessage varchar(max) NULL,\r\n\tDatasets varchar(max) NULL, \/*if ReportType=local and report file is using dataset(s) then supply data in this column (multiple values must be pipe delimited). e.g. Dataset1|Dataset2)*\/\r\n\tDatasetConnectionStrings varchar(max) NULL, \/*if ReportType=local and report file is using dataset(s) then supply data in this column (connection string must be same order as datasets (multiple values must be pipe delimited) enter just one connectionstring if all datasets using same connection. ConnectionString must be ADO.NET for SQLServer, ODBC or OLEDB connection string and correct driver must be installed on the system)*\/\r\n\tDatasetQueries varchar(max) NULL \/*if ReportType=local and report file is using dataset(s) then supply data in this column (queries must be in the same order as dataset(s) listed in Datasets column. enter multiple queries in this format &lt;xml&gt;&lt;query&gt;{query for 1st dataset}&lt;\/query&gt;&lt;query&gt;{query for 2nd dataset}&lt;\/query&gt;&lt;\/xml&gt;)*\/\r\n);\r\n<\/pre>\n<p>&nbsp;<\/p>\n<div id=\"attachment_4100\" style=\"width: 499px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-data-driven-table-t-sql-code.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4100\" class=\"size-full wp-image-4100\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-data-driven-table-t-sql-code.png\" alt=\"Data-driven table in SSRS\" width=\"489\" height=\"332\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-data-driven-table-t-sql-code.png 489w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/ssis-data-driven-table-t-sql-code-300x204.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/a><p id=\"caption-attachment-4100\" class=\"wp-caption-text\">Sample Database in SSIS for SSRS<\/p><\/div><\/li>\n<li>Finally, you can check the table with the configuration:\n<div id=\"attachment_4102\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-data-driven-config-in-SSIS.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4102\" class=\"size-full wp-image-4102\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-data-driven-config-in-SSIS.png\" alt=\"SSIS data-driven table in SSRS\" width=\"839\" height=\"137\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-data-driven-config-in-SSIS.png 839w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-data-driven-config-in-SSIS-300x49.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSRS-data-driven-config-in-SSIS-768x125.png 768w\" sizes=\"(max-width: 839px) 100vw, 839px\" \/><\/a><p id=\"caption-attachment-4102\" class=\"wp-caption-text\">Data-driven table created in SSIS<\/p><\/div><\/li>\n<\/ol>\n<h3>Calling SSRS Reports in SSIS to Export local report option<\/h3>\n<p>With local reports, you can work with rdl files. The rdl (Report Definition\u00a0Language) files are part of\u00a0the SSRS. They are physical files that contain the report format and other\u00a0components. Using the export local report you can customize queries and see the\u00a0results as reports. Here we will explain how to do it.<\/p>\n<ol>\n<li>First of all, in the Reporting Services task in Visual Studio, make sure to select the option Export local report.<\/li>\n<li>Secondly, in report path, you need to specify your rdl file path.<\/li>\n<li>In addition, check the dataset. The dataset is usually detected by default. It is included in the SSRS.<\/li>\n<li>Also, in Dataset Constr, you will need to specify the connection\u00a0information. You need to specify the SQL Server name, Database name,\u00a0Authentication type. For more information about connection string, click <a href=\"https:\/\/docs.microsoft.com\/en-us\/dotnet\/framework\/data\/adonet\/connection-string-syntax\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/li>\n<li>Finally, in dataset queries, you need to specify your query using the XML and\u00a0query tags:\n<div id=\"attachment_4103\" style=\"width: 635px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Export-local-report-query-dataset-connection-string.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4103\" class=\"size-full wp-image-4103\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Export-local-report-query-dataset-connection-string.png\" alt=\"SSRS report in SSIS\" width=\"625\" height=\"665\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Export-local-report-query-dataset-connection-string.png 625w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/SSIS-Export-local-report-query-dataset-connection-string-282x300.png 282w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-4103\" class=\"wp-caption-text\">SSIS local SSRS report<\/p><\/div><\/li>\n<\/ol>\n<h2>Conclusion<\/h2>\n<p>In summary, calling SSRS Reports in SSIS is a straightforward task using the ZappySys\u00a0Reporting Service task. In this article, we learned how to export a Reporting\u00a0services Report to a file. Also, we learned how to send emails using SSIS with the report\u00a0attached and we also learned how to rename, copy files and finally how to use\u00a0Data-Driven configuration and create queries to local reports. If you liked the tool, you can download it <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\" target=\"_blank\" rel=\"noopener\">here.<\/a><\/p>\n<h2>References<\/h2>\n<p>Finally, refer to these links for more information:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/reporting-services\/reporting-services-tutorials-ssrs?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\"> Reporting Services Tutorial<br \/>\n<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-report-generator-task\/\" target=\"_blank\" rel=\"noopener\">SSRS Task in SSIS<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction about calling SSRS Reports in SSIS Calling SSRS Reports in SSIS is straightforward using the ZappySys Reporting Services task. Also, we will show how to export files SSRS files using SSIS, how\u00a0to send reports in emails and how to send parameters. In addition, we will be using this\u00a0ZappySys SSIS PowerPack\u00a0component to make things work: [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":4022,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47,348],"tags":[22,12,301],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-06-16T20:07:59+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-06-22T15:23:45+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"260\" \/>\r\n\t<meta property=\"og:image:height\" content=\"261\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/\",\"url\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/\",\"name\":\"Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\",\"datePublished\":\"2018-06-16T20:07:59+00:00\",\"dateModified\":\"2018-06-22T15:23:45+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png\",\"width\":260,\"height\":261,\"caption\":\"Logo of Reporting Services\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calling SSRS Reports in SSIS (Export \/ Email)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog","description":"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/","og_locale":"en_US","og_type":"article","og_title":"Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog","og_description":"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.","og_url":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/","og_site_name":"ZappySys Blog","article_published_time":"2018-06-16T20:07:59+00:00","article_modified_time":"2018-06-22T15:23:45+00:00","og_image":[{"width":260,"height":261,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/","url":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/","name":"Calling SSRS Reports in SSIS (Export \/ Email) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png","datePublished":"2018-06-16T20:07:59+00:00","dateModified":"2018-06-22T15:23:45+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"Calling SSRS Reports in SSIS can be done using the SSIS Reporting Services task to export SSRS Reports to files or send them as attachments.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/06\/reporting-services-logo.png","width":260,"height":261,"caption":"Logo of Reporting Services"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/calling-ssrs-reports-in-ssis-export-emai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Calling SSRS Reports in SSIS (Export \/ Email)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4008"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=4008"}],"version-history":[{"count":30,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4008\/revisions"}],"predecessor-version":[{"id":4208,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4008\/revisions\/4208"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/4022"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}