updating automatically an SSAS 2005 cube

hello to every one. i have a small problem. well in order to create the data source for my cubes i created a relational database (static) by merging 2 databases . i order to do that, i used integration services. my question is how can i update/add data to my cubes automatically?do i need to add data to the ralational database by running the application over and over (when the 2 databases are updated), can i do that automatically and update the dimensions and the partitions? can i program integration services to look periodically at the two databases and do the update?

thank you in advance for your answers

[625 byte] By [kats] at [2007-12-23]