Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Delete a Data Source in Solution Explorer (Analysis Services)

Use Business Intelligence Development Studio to delete a data source from a Microsoft SQL Server Analysis Services project or database.

To delete a data source

  1. In Business Intelligence Development Studio, open the project or connect to the database from which you want to delete a data source.

  2. In Solution Explorer, expand the Data Sources folder.

  3. Open the Delete Objects dialog box by doing one of the following:

    • Right-click the data source you wish to delete, and then click Delete.

    • Click the data source you wish to delete and press DELETE.

    NoteNote

    To delete multiple data sources, select all of the data sources you want to delete and press Delete or right-click one of the data sources and then click Delete.

    The Delete Objects dialog box appears. If deleting a data source from an Analysis Services project and objects are defined based on the data source being deleted, the objects that will be invalidated are listed in the Delete Objects dialog box.

    Important noteImportant

    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.

  4. In the Delete Objects dialog box, review the data source(s) to be deleted, and then click OK.

    Important noteImportant

    If deleting a data source from an Analysis Services project, you must save the modified project or you will receive an error the next time you open the project because the underlying XML file for the deleted data source will be missing when the project attempts to load the deleted data source.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.