Post reply

Finding a table in a named query in a DSV

  • May 19, 2011 at 3:49 am

    #240625

    HI All

    We currently have approx 500 named queries in a DSV for AS and we want to remove a table from the IS as we think it is not required.

    Before we can do this though we need to check that the named queries don't use the table.

    Other than going into each named query individually, is there a way to "query" the named queries?

    Thanks

    Ant

  • May 20, 2011 at 2:48 am

    #1327517

    Managed to get what I needed.

    To do this, open up the DSV in BIDS, click on VIEW, CODE, this will then bring up the XML for the DSV and then you can do a CTRL+F find for a particular term.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply