View Single Post
  #2 (permalink)  
Old January 7th, 2008, 11:49 PM
Edwin2008 Edwin2008 is offline
Registered User
 
Join Date: Jan 2008
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you very much!

I got a way to do it!, first make a package in SSIS that get the data in XML format and between a data flow task process a dimension directly, it updates the information stored in SSAS.

Previously to make it easy, build another package that get the data in XML format and between a data flow task send all the information to SQL Server, this step is only to make easy the development of the multidimentional structure in SSAS.

I proved it and worked fine!

Atte.
Bach. Edwin Delgado Huaynalaya
Universidad Nacional Jorge Basadre Grohmann - Tacna - Peru
-----------------------------------------------------------
IT Consultant
Bucyrus International (Peru)