How do I set my reprocessing off automatically?

[Welshbird]

First messge posting for me - Here goes - <br>I have built my first cube (eventually and with a steep learning curve!) and have been able to automate the run of my DTS package from the last line of the COBOL which produces the data. What I'm missing is the ability to automatically set of the processing of the cube at the end of the DTS package. Its all based on Microsoft SQL 7 and its OLAP services. Hope fully this is possible - the more I automate the more I can do!<br><br>Please let me know if you can help in any way.<br><br>Regards,<br><br>Fiona<br>mailto:<A HREF="mailto:willif@mosspharmacy.co.uk">willif@mosspharmacy.co.uk</A><br><br>

 

[SQLUser]

1. Download Service Pack 2 for SQL Server<br>2. Download Service Pack 2 for SQL OLAP Services<br>3. Download the add-ins...<br>&nbsp;&nbsp;&nbsp;<A HREF="

http://www.microsoft.com/sql/downloads/DTSKit.htm"

TARGET="_new">

http://www.microsoft.com/sql/downloads/DTSKit.htm</A><br>&nbsp;&nbsp;&nbsp;<A

HREF="

http://www.microsoft.com/sql/downloads/OLAPaddin.htm"

TARGET="_new">

http://www.microsoft.com/sql/downloads/OLAPaddin.htm</A><br><br>I'm

not exactly sure if installing SP2 requires re-booting your machine, but check on it before you install on the Production Server!!!<br><br>

 

[Welshbird]

THank you! - I'm assuming these get run on the server rather than on my client, but I'll have a go and see what happens.<br><br>(If it shouldn't be the server can you give me a yell!)<br><br>Fiona. <p>Fiona Williams<br><a href=mailto:willif@mosspharmacy.co.uk>willif@mosspharmacy.co.uk</a><br><a href= > </a><br>