I call it "smart coding" 🙂

I think developing ETL processes in such a way is a good approach, as long as you don't take it too far.

I haven't seen that error before, but when I click on "Connect" and select "Analysis Services" from the list it doesn't give you the option to specify an initial catalog...

The IP of the SSAS instance will be the same as the IP of the server that's hosting it. You'll have to include the instance name like you've been doing,...

Hash values should not be used in the way you're describing above.

It's usually implemented to help detect changes across multiple attributes in a dimension during the ETL...

The first pattern (truncate & load) is suitable in cases where you either have: 

• A very small fact table
• A fact table where most records change and will have to be updated...

If your variable (ADO_FILENAME) is of type String, you cannot assign a record set (which is what you get when you choose ResultSet type "Full Result Set") to it. You'll...

Yep, that is pretty weird. The only plausible explanation I can think of (and we're speculating of course), is that SSIS might be looking for a later version of the...

I would be curious to know if you could not resolve the issue by explicitly converting the source field (select cast(...)) and then using nvarchar as your destination data type? 

Hi Callum, 

Let's start with some base information...could you please let us know which version/edition of SSAS you are using, as well as whether it is Multidimensional or Tabular....

The calculated measure needs some context to be aware of the level of attributes you are returning. The calculated measure should look something like the following: 

sum

You didn't state that explicitly, but it looks like the Reserve amount is in your fact table instead of your Contract dimension. If that is the case, then it's a...

You can use the Filter() function, similar to the following: https://docs.microsoft.com/en-us/sql/mdx/filter-mdx?view=sql-analysis-services-2017

Interesting scenario, and I'm wondering whether there isn't some background task that's still trying to complete when your second execute SQL task begins. Here's a few initial thoughts in troubleshooting:

• Run...