An information worker who needs to import or export data | -
Install the sample files as described in "Installing and Using the Sample Files." -
Read Chapter 1, "Introduction to Integration Services," to learn the concepts of data transformation. -
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. -
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 | -
Install the sample files as described in "Installing and Using the Sample Files." -
Read Chapter 1 to learn the concepts of data transformation. -
Work through or review Chapters 2, 3, 4, and 5 to learn the core components of package design. -
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. -
Work through or review Chapter 11, "Optimizing SSIS Packages," to learn how to optimize package design and execution. -
Work through Chapter 14 to understand package design best practices. |
A BI architect or solution designer | -
Install the sample files as described in "Installing and Using the Sample Files." -
Read Chapter 1 to learn the concepts of data transformation. -
Work through or review Chapters 2, 3, 4, and 5 to learn the core components of package design. -
Work through Chapters 6, 7, 8, and 9 to learn how to design advanced packages with error handling. -
Work through or review Chapter 11 to learn how to optimize package design and execution. -
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. -
Work through Chapter 14 to understand package design best practices. |
A system or database administrator who needs to configure and optimize a solution | -
Install the sample files as described in "Installing and Using the Sample Files." -
Work through Chapters 10, "Securing and Deploying SSIS Packages," and 11 to learn how to secure, deploy, and optimize packages. -
Review other chapters as needed to understand design elements and best practices. |