KNIGHT'S 24-HOUR TRAINER MICROSOFT SQL SERVER 2008 INTEGRATION SERVICES

This book and video package is geared at introducing DBAs and developers who are just starting to get a handle on Microsoft Business Intelligence tools, and SQL Server Integration Services (SSIS) in particular.  (It is therefore intended to be the first book you read---and the first video you watch--before moving on to Knight's Professional SQL Server 2008 Integration Services.)   The book and accompanying video give the novice reader just enough experience with the product to start their first SSIS project. The book tightly integrates instructional videos--provided on the book's accompanying DVD--with each of the hands-on lessons found in the book.  Each lesson comprises three major components: a lesson which describes how a certain component or process works. a tutorial to walk a user through a micro-process a video where a user can walk through the lesson with the author.

Preface. Welcome To SSIS. Section I: Installation and Getting Started Lesson 1: Moving Data with the Import and Export Wizard. Lesson 2: Installing SQL Server Integration Services. Lesson 3: Installing the Sample Databases. Lesson 4: Creating a Solution and Project. Lesson 5: Exploring Business Intelligence Development Studio. Lesson 6: Creating Your First Package. Section II: Tasks. Lesson 7: Connecting Control Flow Tasks with Precedence Constraints. Lesson 8: Manipulating Files with the File System Task. Lesson 9: Coding Custom Script Tasks. Lesson 10: Using the Execute SQL Task. Lesson 11: Using the Send Mail Task. Lesson 12: Using the FTP Task. Lesson 13: Creating a Data Flow. Section III: Data Flow. Lesson 14: Extracting Data from Sources. Lesson 15: Loading Data to a Destination. Lesson 16: Changing Data Types with the Data Conversion Transform. Lesson 17: Creating and Replacing Columns with the Derived Column Transform. Lesson 18: Rolling Up Data with the Aggregate Transform. Lesson 19: Ordering Data with the Sort Transform. Lesson 20: Joining Data with the Lookup Transform. Lesson 21: Auditing Data with theRow Count Transform. Lesson 22: Combining Multiple Inputs with the Union All Transform. Lesson 23: Cleansing Data with the Script Component. Lesson 24: Separating Data with the Conditional Split Transform. Lesson 25: Altering Rows with the OLE DB Command Transform. Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform. Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform. Section IV: Variables and Expressions. Lesson 28: Making a Package Dynamic with Variables. Lesson 29: Making a Connection Dynamic with Expressions. Lesson 30: Making a Task Dynamic with Expressions. Section V: Containers. Lesson 31: Using Sequence Containers to Organize a Package. Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks. Lesson 33: Using the Foreach Loop Container to Loop Through a Collection of Objects. Section VI: Configuration. Lesson 34: Easing Deployment with Configuration Tables. Lesson 35: Easing Deployment with Configuration Files. Lesson 36: Configuring Child Packages. Section VII: Troubleshooting and Logging. Lesson 37: Logging Package Data. Lesson 38: Using Event Handlers. Lesson 39: Troubleshooting Errors. Lesson 40: Using Data Viewers. Lesson 41: Using Breakpoints. Section VIII: Deployment and Administration. Lesson 42: Deploying Packages. Lesson 43: Configuring the SSIS Service. Lesson 44: Securing SSIS Packages. Lesson 45: Running SSIS Packages. Lesson 46: Scheduling Packages. Section IX: Data Warehousing. Lesson 47: Loading a Dimension Table. Lesson 48: Loading a Fact Table. Section X: Wrap Up and Review. Lesson 49: Bringing It All Together. Appendix A: SSIS Component Crib Notes. Appendix B: Problem and Solution Crib Notes. Appendix C: Whats on the DVD? Index.