SSAS添加环境变量

DECLARE @var sql_variant = N'D:\PB1PD1\opt\xmla' EXEC [SSISDB].[catalog].[create_environment_variable] @variable_name=N'pjXmlaOutputPath', @sensitive=False, @description=N'XMLA格納フォルダ', @environment_name=N'Env_Var', @folder_name=N'B-DashProject', @value=@var, @data_type=N'String'

EXEC [SSISDB].[catalog].[set_object_parameter_value] @object_type=20, @parameter_name=N'pjXmlaOutputPath', @object_name=N'B-DashProject', @folder_name=N'B-DashProject', @project_name=N'B-DashProject', @value_type=R, @parameter_value=N'pjXmlaOutputPath'