SSIS ObjectRef Compatibility Issue

Question

question

HongruQi-5310 asked · Jun 10, 2020 at 10:39 PM

SSIS ObjectRef Compatibility Issue

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?

azure-sql-database azure-data-science-vm

screenshot.png (74.1 KiB)

· 2

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KalyanChanumolu-MSFT · Jun 11, 2020 at 07:14 AM

Could you please post a screenshot for us to understand this issue better

0 ·

HongruQi-5310 KalyanChanumolu-MSFT · Jun 11, 2020 at 01:33 PM

Hi, here is a screenshot of the issue.

0 ·

screenshot.png (74.1 KiB)

Answer 1 · 2020-06-12T06:57:21.423Z

KalyanChanumolu-MSFT answered · Jun 12, 2020 at 06:57 AM

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.

· 2 ·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HongruQi-5310 · Jun 12, 2020 at 05:55 PM

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!

0 ·

KalyanChanumolu-MSFT HongruQi-5310 · Jun 15, 2020 at 10:04 AM

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.

0 ·

question