'How to create partitioning dynamically in SSAS tabular model, without using the SSIS package?

I would like to create the dynamic partition in one of my SSAS tabular model. To do so I found one approach with SSIS package which involves the "Analysis Services Processing Task" & the script task integration, thing is I would like implement this solution without introducing any SSIS package in between, may be via SQL itself (?). Would it be possible?

Thanks.

sqlsql-serverssisssas


Solution 1:[1]

Yes. if you don't want to use SSIS, you can create a job and run your XMLA codes in steps (via SQL Server Analysis services command code step type ) or you can create a linked server between the SQL server database engine and SQL server analysis service tabular and run your XMLA codes

EXEC (xmla_query) AT [Link server name]

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mohsen yousefi

Related Questions