There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
From AdventureWorks To AdventureWorksDW
AdventureWorks and AdventureWorksDW are good samples for transaction and dw.
Is there any sample of SSIS package to load data from AdventureWorks to AdventureWorksDW? For example, I'd like to update AdventureWorksDW db everyday from transaction db.
How about if some dimensions changed, like employees, and productions?