脚本任务的编码和调试

默认情况下，显示在 VSTA 项目资源管理器窗口中的脚本任务项目包含单个项：ScriptMain。ScriptMain 项又包含单个类，名称也为 ScriptMain。该类中的代码元素根据您选择的脚本任务编程语言而有所不同：

• 如果脚本任务配置为 Visual Basic 2008 编程语言，则 ScriptMain 类有一个公共子例程 Main。ScriptMain.Main 子例程是运行脚本任务时运行库所调用的方法。

  默认情况下，新脚本的 Main 子例程中只有一行代码：Dts.TaskResult = ScriptResults.Success。此代码行通知运行库任务运行成功。Dts.TaskResult 属性将在从脚本任务返回结果 中进行讨论。

• 如果脚本任务配置为 Visual C# 2008 编程语言，则 ScriptMain 类有一个公共方法 Main。此方法在脚本任务运行时调用。

  默认情况下，Main 方法包含一行代码：Dts.TaskResult = (int)ScriptResults.Success。此代码行通知运行库任务运行成功。

ScriptMain 项可包含 ScriptMain 类之外的类。这些类仅在它们所在的脚本任务中可用。

默认情况下，ScriptMain 项目项包含以下自动生成的代码：

' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic 2008.
' The ScriptMain is the entry point class of the script.

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime.VSTAProxy

<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _
Partial Class ScriptMain

Private Sub ScriptMain_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup

End Sub

Private Sub ScriptMain_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown
Try
' Unlock variables from the read-only and read-write variable collection properties
If (Dts.Variables.Count <> 0) Then
Dts.Variables.Unlock()
End If
Catch ex As Exception
        End Try
End Sub

Enum ScriptResults
Success = DTSExecResult.Success
Failure = DTSExecResult.Failure
End Enum


' The execution engine calls this method when the task executes.
' To access the object model, use the Dts property. Connections, variables, events,
' and logging features are available as members of the Dts property as shown in the following examples.
'
' To reference a variable, call Dts.Variables("MyCaseSensitiveVariableName").Value
' To post a log entry, call Dts.Log("This is my log text", 999, Nothing)
' To fire an event, call Dts.Events.FireInformation(99, "test", "hit the help message", "", 0, True)
'
' To use the connections collection use something like the following:
' ConnectionManager cm = Dts.Connections.Add("OLEDB")
' cm.ConnectionString = "Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;"
'
' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
' 
' To open Help, press F1.

Public Sub Main()
'
' Add your code here
'
Dts.TaskResult = ScriptResults.Success
End Sub

End Class

/*
   Microsoft SQL Server Integration Services Script Task
   Write scripts using Microsoft Visual C# 2008.
   The ScriptMain is the entry point class of the script.
*/

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime.VSTAProxy;
using System.Windows.Forms;

namespace ST_1bcfdbad36d94f8ba9f23a10375abe53.csproj
{
    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain
    {
        private void ScriptMain_Startup(object sender, EventArgs e)
        {

        }

        private void ScriptMain_Shutdown(object sender, EventArgs e)
        {
            try
            {
                // Unlock variables from the read-only and read-write variable collection properties
                if (Dts.Variables.Count != 0)
                {
                    Dts.Variables.Unlock();
                }
            }
            catch
            {
            }
        }

        #region VSTA generated code
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ScriptMain_Startup);
            this.Shutdown += new System.EventHandler(ScriptMain_Shutdown);
        }
        enum ScriptResults
        {
            Success = DTSExecResult.Success,
            Failure = DTSExecResult.Failure
        };

        #endregion

        /*
The execution engine calls this method when the task executes.
To access the object model, use the Dts property. Connections, variables, events,
and logging features are available as members of the Dts property as shown in the following examples.

To reference a variable, call Dts.Variables["MyCaseSensitiveVariableName"].Value;
To post a log entry, call Dts.Log("This is my log text", 999, null);
To fire an event, call Dts.Events.FireInformation(99, "test", "hit the help message", "", 0, true);

To use the connections collection use something like the following:
ConnectionManager cm = Dts.Connections.Add("OLEDB");
cm.ConnectionString = "Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;";

Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

To open Help, press F1.
*/

        public void Main()
        {
            // TODO: Add your code here
            Dts.TaskResult = (int)ScriptResults.Success;
        }
    }

脚本任务项目可包含默认的 ScriptMain 项以外的项。您可以向项目添加类、模块和代码。您还可以使用文件夹来组织项组。您添加的所有项在包中都将持久化。

在**“项目资源管理器”中右键单击脚本任务项目，然后单击“添加引用”**，可以添加对托管程序集的引用。有关详细信息，请参阅引用脚本解决方案中的其他程序集。

注意
您可以在 VSTA IDE 中的“类视图”或“项目资源管理器”中查看项目引用。这些窗口都可以从“视图”菜单中打开。您可以从“项目”菜单、“项目资源管理器”或“类视图”添加新引用。