Abstract
In the main, the maintenance tasks included with SSIS are wrappers, presented in a graphical format, for T-SQL statements that perform maintenance tasks. What’s nice about these components is that they encapsulate fairly complex statements for you, with all necessary parameters. As such the tasks form a pragmatic though essential toolset for performing maintenance tasks through 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
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 James Wightman
About this chapter
Cite this chapter
(2008). Maintenance Plans. In: Pro SQL Server 2005 Integration Services. Apress. https://doi.org/10.1007/978-1-4302-0448-0_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0448-0_7
Publisher Name: Apress
Print ISBN: 978-1-59059-897-9
Online ISBN: 978-1-4302-0448-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books