Deleting a Data Source in Solution Explorer
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

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.

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.

© 2016 Microsoft