Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

74



LESSON 8 Loading dimensions

The download for this lesson, available at www.wrox.com, includes a script file

that will create the dimension table, a script that modifies data, and the solution

to the Try It section.

Hints

Use the OLE DB source to extract the data from the Sales.SpecialOffer table.



To set the MaxQty column to



0, use the Derived Column transform.

Use the Slowly Changing Dimension Wizard to load the extracted data into the dimension.



Step-by-Step

1. Open and execute Lesson8Create.sql.

2. In BIDS select FileNewProject.

3. Select Integration Services Project.

4. Name the project BI Trainer Packages 8.

5. Place a check next to Create Directory for Solution.

6. Click OK.

7. Ensure that the Control Flow tab is active.

8. Right-click in the Connection Manager of the Control Flow tab and select New OLE DB

Connection.

9. In the Connection Manager screen, type localhost in the drop-down list labeled “Server

name” and type or select AdventureWorks2008 in the drop-down list labeled “Select or enter

database name.”

10. Click OK twice.

11. Right-click the connection in the Connection Manager and select Rename. Change the name

of the connection to Source.

12. Repeat Steps 8 through 11, but instead of selecting AdventureWorks2008 as the database,

select AdventureWorksDW2008 and rename it Destination.

13. Drag a Data Flow task onto the Control Flow design ...