SSIS and PPS data integration demo part I continued...
Part I is continued from my last post on performing PPS Planning data integration using SQL Server Integration Services (SSIS). Forrest Dermid, one of Microsoft's senior technical solutions professionals, gives us a demo that shows you how to load reference data -Account dimension and hierarchy from AdventureWorks. I will follow this post shortly with related notes.
You can also download the SSIS package from which Forrest is working. Read setup instructions from the ReadMe folder and make sure you have the AdventureWorksDW database on SQL Server. I'm sure there are other things you will need to do.
