// C# Code

#region Namespaces

using System;

using System.IO; // Added

using Microsoft.SqlServer.Dts.Runtime;

using System.Windows.Forms;

#endregion

​

namespace ST_719acd579f7e46adb5d68fb2fdd19625

{

  [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]

  public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

  {

​

    public void Main()

    {

      // Get ConnectionString from Connection Manager (case sensitive)

      string filePath = Dts.Connections["OM_DEPARTMENT"].AcquireConnection(Dts.Transaction).ToString();

​

      // Open the file from the connection manager to append some text

      using (System.IO.StreamWriter sw = File.AppendText(filePath))

      {

        // Append text from string variable to file

        sw.WriteLine(Dts.Variables["User::Footer"].Value.ToString());

      }

​

      // Close Script Task with success

      Dts.TaskResult = (int)ScriptResults.Success;

    }

​

    #region ScriptResults declaration

    /// <summary>

    /// This enum provides a convenient shorthand within the scope of this class for setting the

    /// result of the script.

    /// 

    /// This code was generated automatically.

    /// </summary>

    enum ScriptResults

    {

      Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,

      Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure

    };

    #endregion

​

  }

}