Forum Discussion
SSIS / SSAS
SO In short SSIS for transform the data . and SSAS is for analyze the data .. right ?
so i created this package on SSIS .. now how i used this package in 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 ..
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.