Share via

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,610 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,621 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?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.