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 ...
© 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. Carter1
(1)Botley, UK
Get Expert Scripting and Automation for SQL Server DBAs 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.
