Hi all, Does anyone here no if there is a sample AdventureWorks2008 to AdventureWorksDW2008 ETL project (incremental or initial load) available? I have searched the CodePlex site and have not found one. I downloaded a project called AWDataWarehouseRefresh (http://msftisprodsamples.codeplex.com/releases/view/45916) which creates a datawarehouse and loads it (in a single package!). This is not what i'm after. I'm really wanting to see how the allocation of freight costs to order lines is performed i.e. the transactional db stores both freight and tax at the sales order header - the dw db stores this info at the order line. Not sure if this is correct forum for this query....any assistance / links greatly appreciated. Cheers, Clay

If I'm not mistaken, there aren't any ssis packages to load the DW directly from the OLTP database. The DW is loaded from a bunch of .csv files, propably by the AWDataWarehouseRefresh package that you found.MCTS, MCITP - Please mark posts as answered where appropriate.