Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Section 3

Data Flow

• Lesson 18: Extracting Data from Sources
• Lesson 19: Loading Data to a Destination
• Lesson 20: Changing Data Types with the Data Conversion Transform
• Lesson 21: Creating and Replacing Columns with the Derived Column Transform
• Lesson 22: Rolling Up Data with the Aggregate Transform
• Lesson 23: Ordering Data with the Sort Transform
• Lesson 24: Joining Data with the Lookup Transform
• Lesson 25: Auditing Data with the Row Count Transform
• Lesson 26: Combining Multiple Inputs with the Union All Transform
• Lesson 27: Cleansing Data with the Script Component
• Lesson 28: Separating Data with the Conditional Split Transform
• Lesson 29: Altering Rows with the OLE DB Command Transform
• Lesson 30: Handling Bad Data with the Fuzzy Lookup Transform
• Lesson 31: Removing Duplicates with the Fuzzy Grouping Transform

Chapter 18

Extracting Data from Sources

Generally, when you create SQL Server Integration Services (SSIS) packages, it is for the purpose of moving data from one point to another. A source is where you specify the location of the data you want to move or transform.

Most sources point to a connection manager in SSIS. By pointing to a connection manager, you can reuse connections throughout your package because you need only change the connection in one place. In this lesson, the most frequently used sources (OLE DB, Excel, and flat file) are described thoroughly.

NOTE In August 2011, Microsoft announced that SQL Server 2012 would be the last release to support the Microsoft ...