O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_5

5. Automation Techniques with SSIS

Peter A. Carter

(1)Botley, UK

Although its primary purpose is as an ETL (Extract, Transform, and Load ) tool, SSIS (SQL Server Integration Services) provides many automation possibilities for database administrators. In fact, maintenance plans and the Copy Database Wizard are implemented using SSIS. There are many other features that are available in the full SSIS application that can drastically enhance your automation toolset. Additionally, when an automated routine requires a complex flow, an SSIS package can be much easier to develop and maintain than a flow that is implemented through SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required