Since SSIS packages do not share memory with SQL Server and you are not using the DB engine, it seems like it would make sense to reduce that allocation, not...

each one has there own opinion.  it should be left to them. that idle for mutual respect.

i would like to maintain my code in pastebin.

is there any hard rule...

Given any MSKU, what is the lookup logic for getting its Title?

if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query?  If so, I don't think that is...

Try this:

DROP TABLE IF EXISTS #Sales;
DROP TABLE IF EXISTS #FiscalPeriods;

CREATE TABLE #Sales
(
    SOPTYPE SMALLINT NOT NULL
   ,SOPNUMBE CHAR(21) NOT NULL
  ...

What does "not working" mean?

1. Results in an error? (If so,...

Had you been able/prepared to accurately describe...

I am going to let someone else try to help you. I do not understand.

Not very helpful.

It provides the output you requested, so what's the problem?

I found one thing, the packages from colleague A (the ones working) have the scripts as "directinput" whereas the packages from colleague B (the ones throwing error path not found)...

This provides the desired results (I think), but I'm not convinced it's the best solution.

DROP TABLE IF EXISTS #Custom;

CREATE TABLE #Custom
(
    Noseqtrt SMALLINT NULL
...

Taking the case where NoSeqTrt = 4, would it be correct to say that there are eight students at that stop, including two sets of siblings?

And your desired ranking logic...

What does the Number Address column represent, exactly?

What is your question?

Instead of

TRIM(x)

Use

LTRIM(RTRIM(x))