SQL Server Integration Services - MSDN Tutorials

Session 05


05.01. Tutorial: Creating a Simple ETL Package

05.02. Lesson 1: Creating the Project and Basic Package

      05.02.01. Step 1: Creating a New Integration Services Project

      05.02.02. Step 2: Adding and Configuring a Flat File Connection Manager

      05.02.03. Step 3: Adding and Configuring an OLE DB Connection Manager

      05.02.04. Step 4: Adding a Data Flow Task to the Package

      05.02.05. Step 5: Adding and Configuring the Flat File Source

      05.02.06. Step 6: Adding and Configuring the Lookup Transformations

      05.02.07. Step 7: Adding and Configuring the OLE DB Destination

      05.02.08. Step 8: Making the Lesson 1 Package Easier to Understand

      05.02.09. Step 9: Testing the Lesson 1 Tutorial Package

05.03. Lesson 2: Adding Looping

      05.03.01. Step 1: Copying the Lesson 1 Package

      05.03.02. Step 2: Adding and Configuring the Foreach Loop Container

      05.03.03. Step 3: Modifying the Flat File Connection Manager

      05.03.04. Step 4: Testing the Lesson 2 Tutorial Package

05.04. Lesson 3: Adding Package Configurations

      05.04.01. Step 1: Copying the Lesson 2 Package

      05.04.02. Step 2: Enabling and Configuring Package Configurations

      05.04.03. Step 3: Modifying the Directory Property Configuration Value

      05.04.04. Step 4: Testing the Lesson 3 Tutorial Package

05.05. Lesson 4: Adding Logging

      05.05.01. Step 1: Copying the Lesson 3 Package

      05.05.02. Step 2: Adding and Configuring Logging

      05.05.03. Step 3: Testing the Lesson 4 Tutorial Package

05.06. Lesson 5: Adding Error Flow Redirection

      05.06.01. Step 1: Copying the Lesson 4 Package

      05.06.02. Step 2: Creating a Corrupted File

      05.06.03. Step 3: Adding Error Flow Redirection

      05.06.04. Step 4: Adding a Flat File Destination

      05.06.05. Step 5: Testing the Lesson 5 Tutorial Package


Session 06


06.01. Tutorial: Exporting from ODBC to a Flat File Using a Wizard

06.02. Lesson 1: Creating a SQL Server ODBC Data Source

06.03. Lesson 2: Creating an Integration Services Project to Export from ODBC to a Flat File

06.04. Lesson 3: Running the Wizard to Export from ODBC to a Flat File

06.05. Lesson 4: Testing the Lesson Package


Session 07


07.01. Errors and Events Reference (Integration Services)

07.02. Integration Services Error and Message Reference


Session 08


08.01. SQL Server Integration Services Product Samples

Your Comment To AUTHOR