Finding Your Best Starting Point


Although the range of topics addressed in this book is comprehensive, this book also caters to readers with varying skills who are involved in one or more stages of the data transformation life cycle. Accordingly, you can choose to read only the chapters that apply to the activities for which you are responsible and skip the remaining chapters. If you choose to take this approach, we recommend that you at least review the chapters that apply to other roles in order to obtain a broad exposure to the product. To find the best place to start, use the following table.

Open table as spreadsheet

If you are

Follow these steps

An information worker who needs to import or export data

  1. Install the sample files as described in "Installing and Using the Sample Files."

  2. Read Chapter 1, "Introduction to Integration Services," to learn the concepts of data transformation.

  3. Work through Chapters 2, "Building Your First Package," 3, "Extracting and Loading Data," 4, "Using Data Flow Transformations," and 5, "Managing Control Flow," to learn the core components of package design.

  4. Review Chapter 14, "Applying Best Practices to SSIS Package Design," to understand package design best practices.

An information worker or application developer who needs to build an ETL solution

  1. Install the sample files as described in "Installing and Using the Sample Files."

  2. Read Chapter 1 to learn the concepts of data transformation.

  3. Work through or review Chapters 2, 3, 4, and 5 to learn the core components of package design.

  4. Work through Chapters 6, "Scripting Tasks," 7, "Debugging Packages," 8, "Managing Package Execution," and 9, "Detecting and Handling Processing Errors," to learn how to design advanced packages with error handling.

  5. Work through or review Chapter 11, "Optimizing SSIS Packages," to learn how to optimize package design and execution.

  6. Work through Chapter 14 to understand package design best practices.

A BI architect or solution designer

  1. Install the sample files as described in "Installing and Using the Sample Files."

  2. Read Chapter 1 to learn the concepts of data transformation.

  3. Work through or review Chapters 2, 3, 4, and 5 to learn the core components of package design.

  4. Work through Chapters 6, 7, 8, and 9 to learn how to design advanced packages with error handling.

  5. Work through or review Chapter 11 to learn how to optimize package design and execution.

  6. Work through Chapters 12, "Data Warehouse Concepts," and 13, "Populating Data Warehouse Structures," to learn data warehouse concepts and how to populate data warehouse structures.

  7. Work through Chapter 14 to understand package design best practices.

A system or database administrator who needs to configure and optimize a solution

  1. Install the sample files as described in "Installing and Using the Sample Files."

  2. Work through Chapters 10, "Securing and Deploying SSIS Packages," and 11 to learn how to secure, deploy, and optimize packages.

  3. Review other chapters as needed to understand design elements and best practices.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

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