Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
Package package = app.LoadPackage("ssis路径", null);
package.InteractiveMode = true;
Variables vars = package.Variables;
IList keyList = list.GetKeyList();
//设置ssis变量
foreach (string key in keyList)
{
vars[key].Value = list[key].ToString ();
}
DTSExecResult rtn = package.Execute();
if (package.Errors.Count > 0)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine(packagePath);
for (int i = 0; i < package.Errors.Count; i++)
{
builder.AppendLine(package.Errors[i].Description);
}
//记录日志信息
ExceptionLogger.Write(builder.ToString());
}