I have a Dev server (Server1) and a Staging Server (Server2). Both have DQS installed with a Knowledge Base called MyKB.
In SSIS I set up a DQS process using my Dev environment. I link to MyKB on Server1 and map the fields accordingly.
But, if I change the connection for my DQS COnnection Manager from Server1 to Server2 then the reference to the KB is lost and I have to remap all the fields. The same thing happens when I set it back to Server1.
So, how can I set this up so that the link to a KnowledgeBase does not disappear if I change server? Obviously we can't go in and remap everything every time we call the SSIS package on a particuar server. Nor an we have one different package for