利用SSIS更新SSAS多维数据集

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.SqlServer.Dts.Runtime;

 

namespace BI_Test

{

    public class SSASDtsExecute

    {

        ///

        /// 处理DTS包

        ///

        /// 0:处理失败1:处理成功2:缺失配置文件

        public int ExecuteSSASDts()

        {

            Application app = new Application();

 

            //DTS包所在位置

            String strDtsFilePath = System.Configuration.ConfigurationSettings.AppSettings["SSASDtsFilePath"].ToString();

            if (!System.IO.File.Exists(strDtsFilePath))

            {

                return 2;

            }

            //处理包

            Package package = app.LoadPackage(strDtsFilePath, null);

            DTSExecResult result = package.Execute();

 

            if (result == DTSExecResult.Success)

            {

                return 1;

            }

            else

            {

                return 0;

            }

        }

    }

}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7383074/viewspace-539678/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7383074/viewspace-539678/