Friday, December 21, 2007

process analysis services objects through SSIS

There are two methods for populating data into SSAS, which are used mostly for non-standard data sources:

  1. Using Dimension Processing Data Flow Destination
  2. Using Partition Processing Data Flow Destination

You can map your source data into the dimension or Partition, and set the update method which can be Add, Full, or Update.


Pedro said...

Dear Amin,
This is a good subject to write a few words more... give us more feedback in your interesting posts.

Amin said...

Dear Pedro
Thank you for the comment,
I will explain this process better at the future, and I try to explain other subjects in detail. ;)
This post and the two previous posts are related to each other, in order to take a look on the data population process.