DQS Cleansing transform in SSIS want to parameterize KB name

Question

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?

Answer 1

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?

Answer 2

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.