Thanks to everyone but the input.

No new code, nor report was released. I also don't get any blocks.

We found yesterday that we had we had the tempdb and the data...

I only get the error when the tabular models are processing.

Hi, we have an enterprise edition.

We are running on the same virtual machine the SSAS and SSIS, nothing else apart from that.

I capped it to 100 max for the sql...

thanks, i needed to do it dynamically, i was just not sure how to go about it.

OKI, here is what happened but we dont understand why. the query that was running until yesterday it is not running anymore.

we try changing the data type to nvarchar and...

I tried, but we are still having records that are unmatched.

that is the weird thing, nothing changed from last night, i will try to change it now.

yesterday loaded without any issue. today i am getting a different result.

Yes, but yesterday I was getting C0FB8B944A767E1AACE82F930D95E69ED912ADAD using the same, and today using the same SSIS process we also got C0FB8B944A767E1AACE82F930D95E69ED912ADAD.

I am running the following query. of a table that loaded last night using SSIS, which we use every night.

select *, CURRENCY_ID,
CONVERT(CHAR(40), HASHBYTES('SHA1', LTRIM(RTRIM(COALESCE(CURRENCY_ID,'')))), 2)AS CurrencyHashKey ...

it is weird. I am not sure.

for example the process run last night. the hash that I got from SSIS using the same process we always use that was matching...

i upgraded to 18.8, but i will check, thanks to all of you. i think it is a problem on my side, i know the code was working.

Hi,

I get the object id, it stopped working when I updated the management studio, i think it is not the code, but rather a new thing i need to enable.

it is a table and it does have null columns.

Thanks to both of you, Mike01 it works, thanks!!