SSIS ObjectRef Compatibility Issue

Hongru Qi 1

In the SSIS Dimension Processing Destination, there is an ObjectRef statement originally written in ASSL. However, it reports compatibility issue saying that the interface is not supported. Our DBA suggested that he attempted to upgrade Tabular model to SQL 2017 comp level worked, however is stuck on the ObjectRef statement in the SSIS Dimension Processing Destination, that requires new syntax in TMSL language, to reference dimension. And the project can be run on a SQL server without upgraded patch.

Can anyone help me with this problem?

KalyanChanumolu-MSFT 8,316 Reputation points

2020-06-11T07:14:09.09+00:00

Could you please post a screenshot for us to understand this issue better
Hongru Qi 1 Reputation point

2020-06-11T13:33:48.307+00:00

Hi, here is a screenshot of the issue.

1 answer

KalyanChanumolu-MSFT 8,316 Reputation points

2020-06-12T06:57:21.423+00:00

From your description of the issue I gather that you have already performed the upgrade to Compatibility Level 1200. It is a one way upgrade and is not reversible.

If this is the case, the scripts that you run against the tabular models will need to be recreated using TMSL as well.

Here is the scripting language matrix for Analysis Services data models across different versions, at specific compatibility levels.
Please sign in to rate this answer.
Hongru Qi 1 Reputation point

2020-06-12T17:55:40.827+00:00

The issue started after the patch CU20 was applied to SQL Server 2017, it appears the Dimension Processing is no longer supported in Visual Studio. Our DBA suggests correcting the ObjectRef syntax for the Dimension Processing, but no guarantee it will work.

The current ObjectRef for the Dimension Processing in ASSL:
<Object xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<DatabaseID>DatabaseTEST</DatabaseID>
<DimensionID>Query</DimensionID>
</Object>

Do you know what is the correcsponding syntax in TMSL?
Thank you!

KalyanChanumolu-MSFT 8,316 Reputation points

2020-06-15T10:04:19.013+00:00

Please check the Refresh command (TMSL) for the syntax. The examples section has the complete snippet.

The default behavior is to use as much parallelism as possible.

You can use the Sequence command (TMSL) along with Refresh to adjust the parallelism by tweaking the maxParallelism property

---

If this answers your query, please “Accept Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .
And, if you have any further queries do let us know.
Sign in to comment