DQS Cleansing Component Keeps Failing - SSIS


  • I have several SSIS packages which contain a DQS Cleansing Component. For some reason, the DQS Cleanse portion keeps failing with the following error:

    The GUID in the error message leads me to believe there's some kind of connection string issue, but all the connections in the package have been set using environment variables.

    The DQS Knowledge base has been published and is available.

    Aside from those couple of things, I can't think of anything else that could be wrong.

    Any insight would be great!


    A. M. Robinson

    Wednesday, July 09, 2014 7:09 PM


  • It turns out there was a database name that was causing it to error. Apparently DQS iterates through all the user databases when doing its work and the badly named database threw it off.

    A. M. Robinson

    • Marked as answer by ansonee Thursday, August 14, 2014 2:16 AM
    Thursday, August 14, 2014 2:16 AM