none
DQS Table names in SQL DB

    Question

  • Hi Team,

    I have been using DataQualityServices tool (SQL Server 2012) to create DQS Matching and Cleansing. I would like to see the created knowledge base tables (Ex: Supplier_knowledgebase) in SQL Server Management Studio. However, its not working.

    SELECT

    *

    FROM[DQS_MAIN].[KnowledgeBase1000025].[B_REFERENCE_DATA_MAPPING]

    Can anyone please help me to view the DQS tables in SQL Server Management Studio. Please provide me the steps.

    Thanks,

    P.K.Divakar

    • Moved by ArthurZMVP Thursday, July 10, 2014 2:35 PM Does not appear SSIS related
    Thursday, July 10, 2014 11:41 AM

All replies

  • What is the error message you are getting ?

    Have you check what is the permission you are having ? Who has created the tables ?

    http://msdn.microsoft.com/en-us/library/hh213045.aspx


    Raju Rasagounder Sr MSSQL DBA


    Thursday, July 17, 2014 1:05 AM
  • I'm able to select from the tables. Whats the error you got?

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, July 17, 2014 1:39 AM