如何从 SSIS 包提示输入? [英] How do I prompt for input from an SSIS package?

问题描述

我希望能够在我的 DTSX 包中有一个 sql 查询，并且我希望能够有某种提示来更新空列的值.看看我下面有什么:

I want to be able to have a sql query in my DTSX package and I want to be able to have some sort of prompt to update the value of a null column. See what I have below:

UPDATE  SF1411
SET     [QuoteNumber]   = '123456'
    ,   [ItemNumber]    = '123654-100'
    ,   [DeleteItem]    = 'NO'
WHERE   [QuoteNumber]   = '0'

我希望能够提示输入 QuoteNumber 和 ItemNumber，然后根据需要更新脚本.这是可能的，如果可以，我该怎么做?

I want to be able to be prompted for the QuoteNumber and ItemNumber, then have the script update as needed. Is this possible and if so how can I do it?

推荐答案

这可以如下实现:这将在您的初始脚本组件中.

This can be acheived as below: This will be in your intial script component.

    System.Windows.Forms.Form frm = new Form();
    TextBox txt = new TextBox();
    Button inputset = new Button();

    public void Main()
    {
        inputset.Text = "Set Variable Value";
        inputset.Width = 200;
        inputset.Height = 100;
        inputset.Click += new EventHandler(inputset_Click);
        txt.Name = "Input";
        frm.Controls.Add(txt);
        frm.Controls.Add(inputset);
        frm.ShowDialog();
        MessageBox.Show(Dts.Variables["Value1"].Value.ToString());


        Dts.TaskResult = (int)ScriptResults.Success;
    }

    void inputset_Click(object sender, EventArgs e)
    {
        Dts.Variables["Value1"].Value = Convert.ToInt32(txt.Text);
        frm.Close();
    }

这应该是您的包中的初始组件，用于设置变量值或构建您的 SQL 命令.

This should be the initial component in your package to set the variable value or construct you SQL Command.

这篇关于如何从 SSIS 包提示输入?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！