Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2016). Automation Techniques with SSIS. In: Expert Scripting and Automation for SQL Server DBAs. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1943-0_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1943-0_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1942-3
Online ISBN: 978-1-4842-1943-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books