Abstract
Thus far, the ETL process has taken us through a lot of decision making. Data has had to be cleaned up and handled with care to ensure it is accurate and that it can be worked with. In Chapter 7, we created an SSIS package and set up our data connections. We also configured and tested the Execute SQL tasks.
Sometimes good things fall apart so better things can fall together. —Marilyn Monroe
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
© 2012 Randal Root and Caryn Mason
About this chapter
Cite this chapter
Root, R., Mason, C. (2012). Concluding the ETL Process with SSIS. In: Pro SQL Server 2012 BI Solutions. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3489-0_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3489-0_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3488-3
Online ISBN: 978-1-4302-3489-0
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)