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 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 ...