<div>
As far as I'm aware, no matter where you do it - at source (then backup/restore as abf) or destination you have to modify them individualy.
</div>


As far as I'm aware, no matter where you do it - at source (then backup/restore as abf) or destination you have to modify them individualy.

<div>
This would change all of them to the same thing, of course, but you could add in some fine tuning if need be.<br />
<br />
Just execute that step, delete the ActiveXScript task, and save the package.
</div>


This would change all of them to the same thing, of course, but you could add in some fine tuning if need be.

Just execute that step, delete the ActiveXScript task, and save the package.

<div>
Very clear and handy solution.... <br />
thank you very much
</div>


Very clear and handy solution....
thank you very much

<div>
<div class="content wysiwyg-content">
Hi,<br />
we have sql server 2000 database with some packages containing quite olap cubes. Cubes are in a separate server machine that has Analysis Services. But we have removed the cubes to another server and the cubes in the package point to the the cubes to the old server. Is there any quick method to change to the new server's cubes without to change them individually one by one?<br />
Thanks
</div>
</div>


Hi,
we have sql server 2000 database with some packages containing quite olap cubes. Cubes are in a separate server machine that has Analysis Services. But we have removed the cubes to another server and the cubes in the package point to the the cubes to the old server. Is there any quick method to change to the new server's cubes without to change them individually one by one?
Thanks

OLAP CUBES IN A PACKAGE

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.