As TangoVictor mentions, there are other possibilities.

One is to keep the filename exactly as it is and instead modify your 'subsequent processing' tasks to use a variable file name. This...

In Excel, you see the incorrect...

SELECT ItemCode from T1 UNION SELECT ItemCode from T2

Thank you very much! If you have trouble getting this...

Hello,

So basically I have an SSIS package that fails when I use an older version of excel (xls). I cannot change the way the excel file is loaded since...

This seems a bit terse. What are you trying to achieve?

Note that many people (including me) choose not to open non-text attachments –...

Yup, I was one of the 'most people' crowd, thanks for alerting me to that, Jeff. Always good to be aware of these extra possibilities. It was also only recently...

We cannot give you a definitive answer, because we can't see your data or table structures. But the fact that each of the queries works individually, but not when joined,...

Wow, never even seen that function before, cool stuff, Steve.

Here is a quick solution. There will be more elegant ways, I'm sure:

DROP TABLE IF EXISTS #t;

CREATE TABLE #t
(
    Col1 CHAR(1) NULL
  ...

Are you hoping for some T-SQL, or are the suggestions already provided sufficient?

Can you tell us what you would like the answer to be, for your example of 295, 3, 0?

One formula which avoids the problem is to calculate any two of...

I created a temp table and inserted your XML doc into it. The following code worked for me

SELECT ChannelId = v.n1.value('(.)[1]', 'INT')
FROM #SomeXML sx
   ...

You need to change the role memberships within MSDB. Untick everything except db_owner and try again.

Where is the DDL, sample data, desired results?

Merely providing a mass of unformatted code is not the way to get results, as you well know.