Considerations when Bringing Data into Data Flow
Integration Services uses the data flow engine to extract data from a data source, transform and modify the data once it is in the data flow, and then load it to an external data store. The data flow engine uses data flow sources for extracting data from a data store. Figure 9-1 shows how the data is being extracted and parsed by a data source; it also shows how an erroneous record will be handled.
In Figure 9-1, two records demonstrate how data flows through a data flow source. As the data flow source reads the data ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services 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.
