I get this error an estimated 90% of the time. I know now to simply...

If you search other forums, you will see that this is commonly known as the 'silent truncation issue'. The most common workarounds appear to be as follows:

1. Do your length...

Interesting.

It would appear that the second and subsequent executions of declare @spec are completely ignored.

As there is no way (as far as I know) of destroying or amending a table...

Simply reading from a table that is being written to should not cause a deadlock. Are you sure that the read queries are causing the deadlocks?

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 year, 5 months ago by Phil Parkin.