I have loaded databases AdventureWorksDW2014 and AdventureWork2014. With the data as originally loaded, the SCD does nothing as there is nothing to do. I wanted to see some records flow through the 'Historical Attributes Inserts Output' so I updated one employee's territory via but still no records were changed. I went ahead and changed SalesTerritoryHistory to agree with SalesPerson, but this did not help. Has anyone arranged for the records to be processed by this branch of the code?

Also, I changed the middle name of the same member, and the 'Changing Attribute Updates' branch of code also failed to execute. I ran both my package and the package downloaded off the WROX site.

I added a new sales person to AdventureWorks2014 and this person passed through the SCD to the insertion but the insertion failed because field NameStyle does not accept nulls. NameStyle is not accounted for the SQL statement of the OLEDB source.