You need a closing parenthesis on your iif

Assuming you are serious, yes you can simulate division with subtraction. No, wait! Surely you can't be serious! ("I am serious, and please don't call me Shirley!")...

try to move the logic from vbscript to sql and use dbmail to send the email

either the left or the right side of your if statement is returning more than one value. Execute them separately to see which one it is. Then, make...

Why not just write a script task to do the same thing? It should only be a few lines of code.

It's just ridiculous that MS couldn't spend an extra developer day adding formatting to THROW. All they had to do is copy that logic from RAISERROR!

Found the answer. This is a feature, not a bug! SSIS always encloses the entire argument string in double quotes. This makes it useless for (directly) running...

Tried that. Same result

fwiw I tried your text with all available collations. Results below.

SQL_Latin1_General_CP437_BIN produced the results where you set it to a variable

query to do it:

declare @foo varchar(100)

set @foo = '¨ª¥³'...

You can also specify collation when you set the variable, e.g.

set @foo = 'bar' COLLATE Latin1_General_CS_AS_KS_WS

COLLATION! That's a likely suspect. Can you find the collation of the databases where it works and compare it to those where it doesn't?

Sorry, I missed the output on the first read.

Can you post the function? I'm wondering if it returns NVARCHAR and the problem you're seeing is in converting it to...

1. please post the different results

2. is it possible that the remote table was updated between the two queries?

The first thing I would do is ask a bunch of questions:

1. Who are the stakeholders for the BI output?

2. What do they think the system should produce?

3. Are we...

At the risk of being a little sarcastic, if you're not sure how to get started on the problem, I'd say the employer is probably looking for someone with more...