I have a requirement to rename the OLAP database using Script. After I
rename, I need to add roles to the OLAP database.

I am planning to do this using Active X components in DTS packages.

Can someone help me on the same.

Thanks
Gomathi

GS wrote:
Look at DSO, this is object model you can use to manipulate OLAP
objects. The microsoft.public.sqlserver.olap newsgroup may be a better
place to ask this.

--
Darren
http://www.sqldts.com
http://www.sqlis.com