Abstract
In the previous chapter, you looked at how SSIS pulls data from point A and pushes it out to point B. In this chapter, you’ll begin exploring the different types of data manipulations, referred to as transformations, which you can perform on your data as it moves from its source to its destination. As Carly Fiorina indicated, our ultimate goal is to start with raw data and use it to reach a state of insight. Data flow transformations are the key to moving your raw data along the first half of that journey, turning it into usable information.
The goal is to transform data into information, and information into insight.—Carly Fiorina
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 Francis Rodrigues, Michael Coles, and David Dye
About this chapter
Cite this chapter
Rodrigues, F., Coles, M., Dye, D. (2012). Data Flow Transformations. In: Pro SQL Server 2012 Integration Services. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3693-1_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3693-1_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3692-4
Online ISBN: 978-1-4302-3693-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books