Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Answer Question   |  March 10, 2009  6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task

must Access be installed to use Analysis Server
Working with Analysis Manager Version: 8.00.194, my Sales cube looks good until I try to browse the data that comes from Foodmart 2000.mdb. Is this because Access is required?

Answer Question   |  September 20, 2008  5:10 PM
Analysis Manager, Database, Microsoft Access, SQL Server