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?

Thanks!

-Z

Project REAL has examples.

http://www.microsoft.com/sql/solutions/bi/projectreal.mspx|||

Phil Brammer wrote:

Project REAL has examples.

http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

Phil,

Does it have examples of using AdventureWorks though? I didn't think so. I admit I haven't looked at the Project REALstuff in too much detail.

-Jamie

|||Z,
Project REAL doesn't go against AWDW, but the concepts would be the same...

Another good resource (again not specific to AdventureWorks) is the Ralph Kimball Group Webcast.

Here are some tutorials (have you looked at MSDN at all?) from Microsoft that are against AWDW.|||

Hi, Phil,

Thanks much for your quick response. It helps a lot!

BTW,

Do you happen to know if there is any sample for the daily changes from DW to SSAS?

-Z

|||

ZZhang wrote:

BTW,

Do you happen to know if there is any sample for the daily changes from DW to SSAS?

-Z

That I cannot help with! That's out of my knowledge area!|||I am looking for advetureworkdb to advetureworkdw plus full digram of advetureworkdw