SSIS script task doesnt populating data for SSAS tabular model properties

Question

I am using ssis script task to get ssas property information like database name, database id, last processed date,last schema update and status .we have migrated from 2012 to 2016 server after that my package is running fine but it is populating only database name to destination table rest is null ,due to this i am facing lot of issues and for multi dimensional cubes data are fine ..only issue with tabular model... Please help me... appreciate your help..

question from:https://stackoverflow.com/questions/65943478/ssis-script-task-doesnt-populating-data-for-ssas-tabular-model-properties

Answer 1

The link you have referenced is for the Multi-dimension model. For Tabular Model, you need to use the: Tabular Object Model

This means that your C# script task has to change. The following is an outline code for getting details of a Tabular Model:

private static void GetCubeDetails()
    {
        //Server
        var server = new Microsoft.AnalysisServices.Tabular.Server();
        server.Connect(CubeConnectionStringDest);

        LogUtil.Log(server.LastSchemaUpdate.ToString());

        //Database
        var db = server.Databases.FindByName(DatabaseNameDest);
        LogUtil.Log(db.LastProcessed.ToString());

        //Model
        var model = db.Model;
        
        //table
        foreach(var table in model.Tables)
        {
            LogUtil.Log(table.ModifiedTime.ToString());

            //partitions
            foreach(var partition in table.Partitions)
            {
                LogUtil.Log(partition.State.ToString());
                LogUtil.Log(partition.RefreshedTime.ToString());
            }
        }


    }