62,072
社区成员
发帖
与我相关
我的任务
分享
private Microsoft.SqlServer.Dts.Runtime.DTSExecResult RunDTS(string filename)
{
Microsoft.SqlServer.Dts.Runtime.DTSExecResult result = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Canceled;
try
{
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
Microsoft.SqlServer.Dts.Runtime.Package pkg = app.LoadPackage(filename, null, true);
result = pkg.Execute();
}
catch (Exception ex)
{
systemLogInfoBll.WriteLog(UserId, hmld_System.ELogType.Error, "DTS 导入", ex.Message);
}
return result;
}
DECLARE @sqlcmd nvarchar(2000)
DECLARE @returncode int
SET @sqlcmd ='dtexec /f "D:\web\cpf\DTS\NEW.dtsx" /CHECKPOINTING OFF /REPORTING EWCDI '
EXEC @returncode = xp_cmdshell @sqlcmd
select @returncode