January 1, 2011 at 6:19 am
i am newbie
i have some doubt's on ssis package
it is possible to create a cube(ssas) using packages(ssis)?
if it is possible, please give me some stuff about how to do this.
i have
SQL server 2008 (enterprise edition) and
Visual studio 2008(SQL Server BIDS 9.0)
wish you a happy new year
thanks in advance
[font="Verdana"]SRIHARI(:~[/font]
January 3, 2011 at 3:54 am
You can process a cube using SSIS (or management studio), but you should construct a cube using BIDS (the same developer interface as for SSIS).
When you create a new project, select the Analysis Services template instead of the Integration Services template.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 3, 2011 at 10:11 pm
thanks this is very helpful to me.....
[font="Verdana"]SRIHARI(:~[/font]
January 3, 2011 at 11:51 pm
miriyalasrihari (1/3/2011)
thanks this is very helpful to me.....
No problem at all. If you have more questions, do not hesitate.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 7, 2011 at 12:17 pm
Since no one can show an example on how to create a cube using SSAS, I have to conclude this technology is not mature enough to be useful in the real world.
February 7, 2011 at 11:40 pm
dave.simmons (2/7/2011)
Since no one can show an example on how to create a cube using SSAS, I have to conclude this technology is not mature enough to be useful in the real world.
Eh? This technology is used by multi-billion companies.
And there are plenty of examples on how to use SSAS. Did you try Google?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply