Summary


SSIS includes the capability to connect to a wide variety of sources with functionality to make the extraction process scalable and flexible, including many ways to target and filter source data. Data extraction requirements are sometimes unique, and will require variations on the examples and design patterns presented here. For example, you may need to combine some of the incremental extraction approaches with dynamic connections and data lineage tracking. But even given the wide variety of requirements you may run into, SSIS provides the functionality to handle many extraction scenarios.

With the extraction component of ETL addressed, the next few chapters will now focus on the transformation and load aspects of ETL applied to data warehousing. Chapter 4 kicks off that discussion with an examination of the processing of dimension tables in SSIS.



Expert SQL Server 2005 Integration Services
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
Year: 2004
Pages: 111

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net