Knight's 24-Hour Trainer Microsoft SQL Server 2008 Integration Services, w. DVD

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

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of ten SQL Server books. Brian has spoken at conferences like PASS, SQL Connections, and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com. Brian watches his 401k wither away in Jacksonville, Florida.Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is a participating member of the local users' group (JSSUG). Visit his blog at http://pragmaticworks.com/community/blogs/.Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS. In his spare time Mike plays guitar and darts. He is a member of the North Florida Dart League.