Forum Discussion
SSIS / SSAS
You do not use this package in SSAS. You can use SSIS to write new data back to the database and then use Visual Studio or Tabular Editor to create a cube based on the data in your tables/views.
After that you deploy the cube to SSAS, process and use it. Please have a look at the link provided above.
HTH!
I created this package (above) which i send is in visual studio .. so after creating the package in SSIS .. what is the next step ? to create a cube or what ?
the links you provided i did not understand so i am asking the questions ..
- ChrisMuthmann2 years agoResolver II
You can write data in a datawarehouse with the SSIS package.
Then you have to decide which kind of analysis service you want to use in the future: tabular or multidimensional?
Then you can use Visual Studio with an SSAS project to create a cube. The connection in this projects is the datawarehouse you have created before.
For more information you can search in youtube e.g. for ssas tutorials.