In the try it lesson when i try to use 'DiscountPct' i get the following error message

"Cannot map columns of different types.
Column 'DiscountPct' is of type 'System.Decimal' and column 'DiscountPct' is of type 'System.Double'." However I did notice that in your try it video this can be selected. I am presuming we are using the same Database of Adventureworks2008 and AdventureworksDW2008

I will appreciate any assistance rendered

This could be a small difference between AdventureWorks2008 and AdventureWorks2008R2. The book used the R2 version of the database which can be downloaded here. http://msftdbprodsamples.codeplex.com/

but the videos on the cd are using '08 instead of '08R2 and they have all been working perfectly till now. The main reason why I bought the book in the first place was because of '08R2
I will try '08R2 and see the difference

I still cant use DiscountPct, I had to use another column

hi with r2
change the create sql scirpt with

CREATE TABLE [dbo].[DimSpecialOffer](
[SpecialOfferKey] [int] IDENTITY(1,1) NOT NULL
CONSTRAINT [PK_SpecialOffer_SpecialOfferKey] PRIMARY KEY CLUSTERED ,
[SpecialOfferAlternateKey] [int] NULL,
[SpecialOfferDescription] [nvarchar](255) NULL,
[DiscountPct] [smallmoney] NULL,

.... othw you would not see the DiscountPct in the slowing changing dimension wizard... becuase of the incompatibile types in r2...
Mario