Deleting a Data Source in Solution Explorer
Deleting a data source is permanent. You cannot restore a deleted data source to a Microsoft SQL Server 2005 Analysis Services (SSAS) database or project. In Analysis Services, data sources provide the basis on which data source views are constructed, and data source views are in turn used to define dimensions, cubes, and mining structures in an Analysis Services project or database. Therefore, deleting a data source may invalidate other Analysis Services objects in an Analysis Services project.
Important
Data sources on which other objects depend cannot be deleted from an Analysis Services database opened by Business Intelligence Development Studio in online mode. You must delete all objects in the Analysis Services database that depend on that data source before deleting the data source.
For more information about how to delete a data source object from a project, see How to: Delete a Data Source in Solution Explorer.
See Also
Concepts
Data Sources (Analysis Services)
Defining a Data Source Using the Data Source Wizard
Modifying a Data Source in Data Source Designer
Other Resources
Working with Data Sources (Analysis Services)