Chapter 10. Business Intelligence

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 report
  • Downloading 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 ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial