Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2007-06-12 : 15:51:49
|
| Hi, all,Some of you may have done this, but how do you integrate a Integration package with Analysis Services?Within my vs solution, I have a SSIS package and a SSAS, which will build a simple cube.At the end of SSIS, it can email, log, or exec another SSIS pkg, etc. but I did not find out a way to fire off the SSAS part. Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 20:34:33
|
| Why build cube in ssis package? |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-06-13 : 16:36:35
|
| No, you misunderstood me. Or I did not make myself clear.Cube is built in SSAS package. SSIS and SSAS share the same solution.If SSIS is successfully ETL the data, then it is SSAS's turn to build OLAP stuff, but how to fire the later based on the satus of the former?In theory, I think SSIS is capable to call a shell cmd type of script, but I just hope there is an easier way. Integrating Integration Services shouldn't be hard. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 21:46:21
|
| There is cube processing task in ssis, but not sure about cube build. Should you build cube in ssms first? |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-06-18 : 12:34:35
|
| Well, yes I did build a Cube in SSAS project. Now I want to figure out how to make the SSIS package integrate with SSAS package.I guess I could always make my SSIS write to a table, and in SSAS, periodically checking that flag field to see if it should kick off, but I just think there might be a better way to do this. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 15:58:36
|
| You like to process cube every time made change in fact table? |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-06-20 : 13:20:26
|
| That is a very good question. Do I need to rebuild Cube? I don't know enough to make the call.The fact tables are uploaded weekly. I guess as long as the schema/structures of these tables did not change, there is no need to rebuild the cube. Then the front end reporting project will drive a query against the cube to get the results. That last part has not been developed. We are currently getting the data through sql2k t-sql.Well, in my SSAS, I am going to do forcasting. Can that be done in SSIS? Then I don't need to have to exec SSAS the SSIS project. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 13:54:53
|
| You don't need to rebuild cube with data changes in fact table, just add cube processing as job step in ssis package job. |
|
|
|
|
|
|
|
|
How to integrate SSIS and SSAS