Yes, add a calculated column to our table/entity: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/ssas-calculated-columns?view=sql-server-2017

I hear you, and deal with similar frustrations on a daily basis. The way in which SSIS parameters and variables are referenced in the later versions of .NET has changed....

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

I stand to be corrected, but I believe it's due to the .NET framework change for VS 2017 (and later versions of SSIS). By changing the namespace reference, you're just...

They way I usually like to solve this is to create an empty file (call it a template) for each source file. I copy the empty files to the processing...

This looks like a typical "fact-less fact" scenario, where the fact table is not a transaction in time but rather the intersection (or existence) between different dimensions.

There's a few...

From what I see above, it looks like there's most likely an implicit conversion between the integer source value and date target value.

I would try to either encapsulate the...

If your target tables are populated from multiple staging/source tables, whether or not you can use CDC really depends on the relationships between the source tables. For instance, if you...

It hasn't really improved, and I'd recommend that you don't use that component at all. Others in the community have developed other design patterns for slowly changing dimensions that you...

BIML can definitely help with everything you've listed here. To give you an idea, I currently use an Excel document (source-to-target mapping) as source for the tables/attributes I want to...

The error is pretty self-explanatory in this case. Your child package has a parameter that needs a value, so you have to pass that value from your parent package when...

You'll have to provide more info to help the folks here help you. What error message are you getting? What parameters and/or SSIS variables are you passing in and how?...

You more than likely have negative numbers in that field.

What's your opinion about it?