从脚本组件读取系统变量

发布于 2024-08-19 17:13:04 字数 743 浏览 9 评论 0原文

从脚本组件读取系统变量的最佳方法是什么？

尝试如下：当用户变量

    base.PreExecute();
    IDTSVariables100 variables = null;
    VariableDispenser.LockForRead("System::ContainerStartTime");
    VariableDispenser.GetVariables(out variables);
    auditTimeStamp = Convert.ToDateTime(variables[1].Value);
    System.Windows.Forms.MessageBox.Show(auditTimeStamp.ToString());
    variables.Unlock();

尝试读取系统变量时，工作正常，抛出以下错误：

脚本组件在用户代码中遇到异常：项目名称：SC_0bfc7da1c6fe4b83bc124b87eb4178e5 HRESULT 异常：

Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100.get_Item（对象索引）处的 0xC0010009 在 ScriptMain.PreExecute() 请在 Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

提供任何线索。

谢谢

原文

What is the best way to read system variables from Script Component.

Tried as below: Works fine when is User variable

    base.PreExecute();
    IDTSVariables100 variables = null;
    VariableDispenser.LockForRead("System::ContainerStartTime");
    VariableDispenser.GetVariables(out variables);
    auditTimeStamp = Convert.ToDateTime(variables[1].Value);
    System.Windows.Forms.MessageBox.Show(auditTimeStamp.ToString());
    variables.Unlock();

when tried to read System variable throws following error:

Script Component has encountered an exception in user code:
Project name: SC_0bfc7da1c6fe4b83bc124b87eb4178e5
Exception from HRESULT: 0xC0010009

at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100.get_Item(Object Index)
at ScriptMain.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()

any clues please.

Thanks

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

可可 2024-08-26 17:13:04

您已将索引从更改

Convert.ToDateTime(variables[1].Value);

为

Convert.ToDateTime(variables[0].Value);

You have changed the index, from

Convert.ToDateTime(variables[1].Value);

Convert.ToDateTime(variables[0].Value);

回复收藏 0 原文

沫雨熙 2024-08-26 17:13:04

好的，完成了，因为

        #region Class Variables

        int jobId;
        DateTime auditTimeStamp;
        IDTSVariables100 variables;
        const string tableName = "ORGANISATION_PROVIDER"; 

        #endregion

        public override void PreExecute()
        {
            #region On PreExecute - Get the JOB ID passed - COMMON
             base.PreExecute();
             variables= null;
             VariableDispenser.LockForWrite("System::ContainerStartTime");
             VariableDispenser.GetVariables(out variables);
             auditTimeStamp = Convert.ToDateTime(variables[0].Value);
             variables.Unlock();

           #endregion
        }

这工作正常..不确定我以前做错了什么。

Ok got this done as

        #region Class Variables

        int jobId;
        DateTime auditTimeStamp;
        IDTSVariables100 variables;
        const string tableName = "ORGANISATION_PROVIDER"; 

        #endregion

        public override void PreExecute()
        {
            #region On PreExecute - Get the JOB ID passed - COMMON
             base.PreExecute();
             variables= null;
             VariableDispenser.LockForWrite("System::ContainerStartTime");
             VariableDispenser.GetVariables(out variables);
             auditTimeStamp = Convert.ToDateTime(variables[0].Value);
             variables.Unlock();

           #endregion
        }

This works fine..not sure what i have done wrong previously.

回复收藏 0 原文