July 13, 2010 at 3:39 am
Hi,
i created a thread for a few weeks, but i got now answer. This thread is in the Integration Services forum.
But my problem is, that i have a 2000 analysis Server, but no 2000 sql Server.
How can i process my analysis 2000 cube automatically every 1 hour ?
July 14, 2010 at 4:50 am
Create a DTS package with a Process OLAP database task. Schedule this package to run every hour.
July 14, 2010 at 5:43 am
yes this is right. but i have no sql 2000 server. so that i can't create and schedule a dts package.
July 14, 2010 at 6:13 am
Install Microsoft SQL Server 2000 DTS Designer Components on your SQL Server 2005 server.
Look for a .dts file to import. Unfortunately you cannot create new DTS packages in the designer.
Now open this package in the designer, alter it to process your olap database. Now use dtsrun to execute this package from an SQL Server Agent Job.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply