Here is a possible approach.

1. Get the code for your DB into a VS database project and check that into a DevOps Git repo.
2. Set the database project to target...

If you would provide just 10 rows of sample data, in consumable format, it would help a lot.

Presumably, your question is not this:

"Why are no results returned when I join on two columns containing values which do not match?"

What is your real question?

The issue is, all of these tables dont have primary/secondary keys, which i brought in with sl code.

Because these keys dont correspond to one another it gives me these...

Like this?

WITH ordered
AS (SELECT *
          ,rn = ROW_NUMBER () OVER (PARTITION BY adc.channelid ORDER BY adc.recordcount DESC)
 ...

You seem to have a lot of Postgres problems ... why not find a Postgres forum?

There is a button that says 'Code' in your icon bar. With >3,000 points, you...

1. Repair Microsoft Visual Studio Tools for Applications. This is a common solution that has worked for many people. To do this, open Control Panel and go to Programs...

Run the package in Visual Studio and add some data viewers in the data flow to find out what's going on and where the missing data is going.

I suggest changing...

Here's a plain-text version for your delight:

SqlException: Snix_Connect (provider: SNI_PN7, error: 40 - SNI_ERROR_40)

Snix_Connect...

As I said, with no ordering, my thoughts are that it's impossible, because the flag could be set against a different row every...

Not necessarily. The program which runs SSIS packages is called DTExec.exe. It has 32-...

I do not understand how your data is ordered – it is neither Col1 nor Col2. Please explain, because without explicit ordering, I do not think that this problem can...

Ideally, all of your DDL should be happening outside of SSIS. Can't tell whether this is the case here.

Use derived columns within your SSIS data flow to populate the non-nullable...

I can't see anything useful in that stack trace. Were there other error messages generated before the trace? Have you identified the exact statement which generates the error by running...

Just noticed that this is a 2012 forum. You'll have to use the old FOR XML PATH method to do the concatenation.