DQS Cleansing transform in SSIS want to parameterize KB name

Yulia Fei 11 Reputation points Microsoft Employee

For the DQS Cleansing transform in SSIS, there is nowhere to parameterize the knowledge base name. Is it possible to change this input into a property?


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,321 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 27,231 Reputation points

    Hi @Yulia Fei ,

    As far as I known, we could not parameterize the knowledge base name.

    Also did some online research that I have not found the way to change this input into a property.



    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Ricardo Silva 1 Reputation point

    The lack of capacity to parametrize the knowledge base reference does impacts the development of any SSIS package that uses this component.
    Deployment for different environments (from DEV to QA to UAT to PROD) requires the developer to edit the package before deploying it which eliminates any chance of deployment automation.
    Microsoft, can you please fix this bug?