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 |
|
asf
Starting Member
7 Posts |
 Posted - 2011-03-06 : 19:48:17
|
| Hi All,I have to process cubes which are on Analysis Services 2000. I want to develop an SSIS 2008 package to process the cubes but I found that SSIS 2008 does not support the analysis services 2000 cubes. So, I was looking at alternative ways to process cubes in SSIS 2008 and found that we can use a script task(vb.net/C#) script to process the cubes.I was thinking of using Script task and use VB.net/C# script and import Microsoft.Analysisservices.DLL in to the script . Does anyone has any idea of how we can use a script task to first process all the dimensions and then the cubes. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-07 : 06:44:55
|
| Can you process the cubes using the sql server agent? In that case you can remove the schedule from the job and fire it off using an execute sql task in ssis.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-07 : 06:46:12
|
| ...and the sql would use the system store procedure sp_start_job: http://msdn.microsoft.com/en-us/library/ms186757.aspx- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
asf
Starting Member
7 Posts |
Posted - 2011-03-10 : 09:04:52
|
| So, you mean just upgrade the dts package and import it in the SSMS 2008 and run it as a sql server agent job? Actually, the package is already upgraded to sql server 2005 and is being run as sql server agent job but I was looking a way to migrate the dts package to SSIS 2008. I think in future the cubes will be moved to SSAS 2008 but for now i was looking for a work around to process the SSAS 2000 cubes in SSIS 2008. |
|
|
|
|
|
|
SSIS - process cubes