Experts, I am learning some skills so I can troubleshoot some performance-related issues. I have gotten good with some basics but when it comes to query which gets the...

Run the tasks in series?

Use project-level connection managers, and then the change is required in one place per target.

Unless the number of tables containing defaults is likely to keep changing, I...

Argh - yes. But how could you ensure that the value for DefaultPK in a given row existed in the table referenced by TableName? My 3NF-violating approach did allow...

And we can obviously manage more than one "table needing a default row" in the new table - one column per such table.

Does anybody know of any drawbacks with...

Are you saying that my code does not work this way?

I've done the emails, the phone numbers and unmatched in the code that follows. You can add the rest yourself.

--Rule 1 - E-mail match
WITH AllEmails
AS (SELECT c.Custno
...

OK, then ordering of the tests becomes important. Please specify the order in which the tests should be applied.

Thank you Phil, great advise.

Sure I will try that. Can you provide some code based on data provided. and No to below question. please

Can the same customer be in...

You mean build a completely separate app and simply call that from SSIS using an Execute Process task? That should work just fine.

• This reply was modified 1 years, 7 months ago by Phil Parkin.

I think this better to do step by step first get all custno into temp table and groupid then updating each found, you know way way better you have seen...

So my question is how can I add these nuget/dll files into ".SSISDeploymentManifest" and install them automatically when I am deploying the package?

As far as I know, you cannot. Adding the assembly...

Your rules are too complex to do this in a single query. Instead, I suggest that you build up the groups one at a time, with one query for every...

I don't think you answered this question:

Can the same customer be in more than one group?

This is a very likely scenario if all of the rules are always applied to...