利用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
【利用SSIS更新SSAS多维数据集】{
return 0;
}
}
}
}

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

    推荐阅读