Any way to execute a DQS project via TSQL


  • I have a client that would like to execute a DQS project to cleanse data via a defined DQS knowledge base.  Ideally he would like to execute it via TSQL and wrap it and other ETL processes in a database transaction.  While we are aware of SSIS components that might allow us to encapsulate things in a transaction the ideal solution would be strictly SQL based.

    Is anyone aware of any APIs or ways to call the stored procs on the DQS database to apply a project via TSQL?

    Any help is appreciated.

    Dienstag, 22. Oktober 2013 19:04