DQS Cleansing transform in SSIS want to parameterize KB name

Yulia Fei 11 Reputation points Microsoft Employee
2022-02-08T08:30:18.847+00:00

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?

172203-1.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,458 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2022-02-09T05:41:43.05+00:00

    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.

    Regards，

    Zoe

    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
  2. Ricardo Silva 6 Reputation points
    2022-02-09T19:06:23.05+00:00

    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?