Chapter 13. SSIS PowerShell Magic

Chapter 12, introduced you to the various Transact-SQL (T-SQL) options for managing the new SSIS Catalog introduced with SSIS 2012. Improving manageability for database administrators was one of the key improvements in SSIS 2012. As part of those improvements, one new feature was the integration of SSIS with PowerShell.

PowerShell Refresher

PowerShell is a Windows command-line shell that enables administrators to perform manageability tasks. It has a command shell prompt as well as a scripting environment that can be used to create PowerShell scripts. It is largely a scripting platform ...

Get Microsoft® SQL Server® 2012 Integration Services 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.