Session 01
01.01. Product Overview
01.02. Typical Uses of Integration Services
01.03. Tools and Utilities Overview (Integration Services)
01.03.01. Integration Services and SQL Server Management Studio
01.03.02. Integration Services in Business Intelligence Development Studio
01.03.03. SSIS Designer
01.03.04. Integration Services Wizards
01.03.05. Command Prompt Utilities (Integration Services)
01.03.06. Query Builder Overview
01.03.07. Expression Builder (Integration Services)
Session 02
02.01. Introducing Business Intelligence Development Studio
02.02. Using SQL Server Management Studio
Session 03
03.01. Package Essentials
03.01.01. Designing Packages in Business Intelligence Development Studio
03.01.02. Creating a Package by Running a Wizard
03.01.02.01. How to: Run the SQL Server Import and Export Wizard
03.01.02.02. How to: Create a New Integration Services Project
03.02. Creating a Basic Package (SQL Server Video)
Session 04
04.01. Tutorial: Creating a Basic Package Using a Wizard
04.02. Lesson 1: Creating the Basic Package
04.02.01. Step 1: Creating the Integration Services Project
04.02.02. Step 2: Running the Wizard to Create the Basic Package
04.02.03. Step 3: Testing the Lesson 1 Basic Package
04.03. Lesson 2: Enhancing the Basic Package
04.03.01. Step 1: Copying the Lesson 1 Basic Package
04.03.02. Step 2: Updating the Execute SQL Task
04.03.03. Step 3: Adding and Configuring the Sort Transformation
04.03.04. Step 4: Adding and Configuring the Derived Column Transformation
04.03.05. Step 5: Modifying the OLE DB Destination
04.03.06. Step 6: Testing the Lesson 2 Basic Package