In this chapter, we will cover the following topics:
Listing items in your SSRS Report Server
Listing SSRS report properties
Using
ReportViewer
to view your SSRS reportDownloading an SSRS report in Excel and as a PDF
Creating an SSRS folder
Creating an SSRS data source
Changing an SSRS report's data source reference
Uploading an SSRS report to Report Manager
Downloading all SSRS report RDL files
Adding a user with a role to an SSRS report
Creating folders in an SSIS package store and MSDB
Deploying an SSIS package to a package store
Executing an SSIS package stored in a filesystem or a package store
Downloading an SSIS package to a file
Creating an SSISDB catalog
Creating an SSISDB folder
Deploying an ISPAC file to SSISDB
Executing an SSIS package stored in SSISDB
Listing SSAS cmdlets
Listing SSAS instance properties
Backing up an SSAS database
Restoring an SSAS database
Processing an SSAS cube