Your SELECT includes 5 items, yet your Result section includes only one (per instance). Can you change your result to match the query (or vice versa)?

Also, are you aware that...

Can you please clarify exactly what you want by providing an example showing

a) Original text and

b) Desired text?

Can you provide sample (sanitised) XML for one single student's data?

I noticed that for those tables with non-unique cluster key columns, SQL adds an internal unique identifier. Is there a way to retrieve a single row using this internal...

The way I've been working for the last few years is to have the 'remote git' part...

I have not seen package files disappear, though I've certainly seen the text in Script Tasks disappear in the past.

Hopefully you've got source control (even if it's just a local...

There is no Except. You need to name your columns.

INSERT B (Col1, Col2)
SELECT Col1, Col2  
FROM A

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

Thank for the many replies....the idea is show the first row of others. The point is that I need to "call" same columns just to apply a filter into...

Multi tenant didnt work due to business contract rules. We only have 3 clients. I do have a question though. Would using the other enviroment in the SQL agaent...

Could you provide an example of the source data in the three tables, also what you are currently seeing, followed by what you would like to see?

OK, but what is your question?

Your desired format is difficult to understand, can you make it clearer?

There is more than one way, but you could do the following:

1. Create an SSISDB environment for each client and put all of the client-specific variables in them, keeping the...

"for some reason..."

SUBSTRING() does not work with wildcards.

Something like this should do the trick:

upper(left(token( @FileName,"\\",tokencount( @FileName, "\\" )), 3)) == "XYZ" && upper(right(token( @FileName,"\\",tokencount( @FileName, "\\" )),4))...

Even if different server specs does turn out to be the reason, it seems that you have learned quite a lot of new things during the whole investigative process, which...

Just tested Chris' solution and it seems to do the job.