SSIS脚本任务错误消息

本文关键字：消息 错误 任务 脚本 SSIS | 更新日期: 2023-09-27 18:27:48

我在运行SSIS包时收到以下错误消息。脚本任务正在使用Microsoft Visual C# 2008。你能帮我解决这个问题吗？

非常感谢！我还附上错误信息：

Error: 2015-12-22 02:58:08.28
   Code: 0x00000001
   Source: Script Task 
   Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
   at System.Windows.Forms.MessageBox.ShowCore(IWin32Window owner, String text, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, MessageBoxDefaultButton defaultButton, MessageBoxOptions options, Boolean showHelp)
   at System.Windows.Forms.MessageBox.Show(String text)
   at ST_d27b216cd7d64713b54c81f6ac28d805.csproj.ScriptMain.Main()
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
   at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()
End Error
DTExec: The package execution returned DTSER_FAILURE (1).

C#代码：

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
namespace ST_d27b216cd7d64713b54c81f6ac28d805.csproj
{
    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
    {
        #region VSTA generated code
        enum ScriptResults
        {
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
        };
        #endregion
        public void Main()
        {
            // TODO: Add your code here
            System.IO.FileInfo fi;
            String FilePath = null;
            DateTime ModifiedTime = (DateTime)Dts.Variables["File_Modified"].Value;

            DateTime LoadDate = (DateTime)Dts.Variables["File_Last_Load_Date"].Value;
            Dts.Variables["isModified"].Value = false;

            FilePath = Dts.Variables["SourceFolder"].Value.ToString();
            ModifiedTime = System.IO.File.GetLastWriteTime(FilePath);
            Dts.Variables["File_Modified"].Value = ModifiedTime; 
            // fi.LastWriteTime;
            int result = DateTime.Compare(ModifiedTime, LoadDate);
            if (result > 0)
            {
                  MessageBox.Show("File Modified after last load in staging");
                Dts.Variables["isModified"].Value = true;
            }
            else
            {
               MessageBox.Show("file is not modified since last load");
                Dts.Variables["isModified"].Value = false;
            }
            Dts.TaskResult = (int)ScriptResults.Success;
        }
    }
}

SSIS脚本任务错误消息

从堆栈跟踪中提取的错误消息是：

当应用程序未在UserInteractive模式下运行时显示模式对话框或窗体是无效的操作。指定ServiceNotification或DefaultDesktopOnly样式以显示来自服务应用程序的通知。

您必须记住，尽管在调试SSIS包时，您有一个很好的UI（BIDS或SQL Server Tools shell，具体取决于您的环境），但实际上它并不是为具有UI而设计的。当此包部署到服务器并由SQL作业调用时，您希望发生什么？即消息框显示在哪里？谁会单击"确定"以允许线程继续？

如果你想发布反馈，你可能只想触发一个信息事件，比如：

bool fireAgain = false;
Dts.Events.FireInformation(0, "Script Task", "File Modified after last load in staging", String.Empty, 0, ref fireAgain);

当应用程序未在UserInteractive模式下运行时，脚本任务试图显示消息框并显示模式对话框或窗体，这不是一个有效的操作，因此引发了此错误。因此，如果您想输出消息，可以使用Dts.Log，请参阅MSDN文档了解更多详细信息。

相关文章：