Summary

You are now familiar with the components of data flow and know how the data is being accessed from the external source by the data flow source, passes through the data flow transformations, and then gets loaded into the data flow destinations. You studied the data flow sources, data flow destinations, and data flow path in detail in this chapter and briefly learned about the data flow transformations. In the next chapter, you will learn more about data flow transformations by studying them in detail one by one and doing Hands-On exercises using many of the transformations.

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.