SQL Server Integration Services - MSDN Tutorials

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

Your Comment To AUTHOR