Forum Discussion
SSIS / SSAS
HI i created a cube in SSIS now i want to use that cubes in SSAS for analysis purpose.. so i want to know how to use it and secondly some one told me that we can not create cubes in SSIS .. is...
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.