Database Reference
In-Depth Information
Listing 19-8.
Code to Place in an
.rss
File to Upload an SSRS Report
CD C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn
RS.exe -i \\RSLAPTOP2\PubsBIProdFiles\DeploySalesByTitles.rss
-s https://rslaptop2/ReportServer/ReportServer
Using SSIS Packages Instead of Batch Files
SSIS includes the ability to run command prompt code using an Execute Process task. Since running command
prompt code is the core of what a batch file does, this feature gives you an alternate way of creating deployment
automation.
For example, you can do the following:
1.
Create an Execute SQL task to run the code needed to restore the database from the
network share.
2.
Add an Execute Package task to run the ETL package.
3.
Add an Analysis Service Execute DDL task to restore the SSAS database.
Add an Execute Process task to call
RS.exe
and upload the report.
4.
Figure
19-4
shows an example of this package.
Figure 19-4.
Creating an SSIS package for deploying your BI solution
