You're not providing enough information for anybody to help. What is the error message? What is the package doing?

There are numerous people in the SQL Server community (including myself) that either have blogs or training content, but you'll have to search their content to find everything you may...

There really isn't an "easier" way to deal with it...you have a many-to-many relationship because of the nature of the data, and you have to model it accordingly.

I'd recommend that...

I use stored procedures to implement the logic (or DML), but still use SSIS (or ADF) to perform the initial extract of the data into a staging area. I do...

Unfortunately not...your only choice is to go with their paid product or stay with the old version of Visual Studio.

Hypothetically speaking, Jeff 🙂

The premise of a Data Warehouse is to store historical information, so that you can go back in time and see what the value of a metric and/or KPI was...

The workspace database, whether locally or on a server, is recreated every time the model is opened in your development environment (Visual Studio or Tabular Editor). Open your model.bim file...

Sure, you're adding rows to the fact table but ultimately it will keep the fact table narrow and you're aggregating a single fact attribute.

In my opinion, create a dimension for Financial Agreements. The dimension would contain all descriptive attributes of the agreement. Create a separate dimension for Asset, which can either have the...

Response duplicated for some reason...please see the other response.

• This reply was modified 2 years, 2 months ago by Martin Schoombee.

To answer your first question...yes it would not be impossible to do that, but it would be tricky because your data source(s) would need to be accessible by each on...

• This reply was modified 2 years, 4 months ago by Martin Schoombee.

Ed's questions are all spot on and you should look to try and answer all of them as part of your troubleshooting process.

My two cents: I'd start with a trace...

• This reply was modified 2 years, 7 months ago by Martin Schoombee.

Can you share the details of the two plans, and the query?

Here's a few articles/blog posts that describe techniques you could use to make this happen:

https://bennyaustin.com/2014/02/20/dynamic-processing/

https://www.sqlservercentral.com/articles/dynamically-process-ssas-cube-from-ssis-package