#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.ScriptTask;
using System.Windows.Forms;
using WinSCP;
#endregion
 
namespace ST_1cff4fb3fdae4184a3e0145198875bbd
{
    /// <summary>
    /// ScriptMain is the entry point class of the script.  Do not change the name, attributes,
    /// or parent of this class.
    /// </summary>
   [SSISScriptTaskEntryPoint]
   public partial class ScriptMain : VSTARTScriptObjectModelBase
    {
 
      /// <summary>
        /// This method is called when this script task executes in the control flow.
        /// Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
        /// To open Help, press F1.
        /// </summary>
      public void Main()
      {
            byte[] emptyBytes = new byte[0];
            string FlatFileName = (string)Dts.Variables["User::FlatFileUploadPath"].Value;
 
            // GoAnywhere SFTP Configuration
            SessionOptions sessionOptions = new SessionOptions
            {
                Protocol = Protocol.Sftp,
                HostName = (string) Dts.Variables["User::SFTPHostName"].Value,
                PortNumber = (int)Dts.Variables["User::SFTPPort"].Value,
                UserName = (string) Dts.Variables["User::SFTPUserName"].Value,
                SshHostKeyFingerprint = (string) Dts.Variables["User::SFTPHostKeyFingerprint"].Value,
                SshPrivateKeyPath = (string) Dts.Variables["User::SFTPPrivateKeyLocation"].Value,
                PrivateKeyPassphrase = (string) Dts.Variables["User::SFTPPassphrase"].Value
            };
 
            try
            {
                using (Session session = new Session())
                {
                    // As WinSCP .NET assembly has to be stored in GAC to be used with SSIS,
                    // you need to set path to WinSCP.exe explicitly,
                    // if using non-default location.
                    session.ExecutablePath = @"C:\Program Files (x86)\WinSCP\winscp.exe";
 
                    // Connect
                    session.Open(sessionOptions);
 
                    // Upload files
                    TransferOptions transferOptions = new TransferOptions();
                    transferOptions.TransferMode = TransferMode.Binary;
 
                    /*-- NOTE: Enter Destination FTP Folder as provided by GoAnywhere Team --*/
                    TransferOperationResult transferResult = session.PutFiles(
                        FlatFileName, "/To_Televox/", false, transferOptions);
 
                    // Throw on any error
                    transferResult.Check();
 
                    // Print results
                    bool fireAgain = false;
                    foreach (TransferEventArgs transfer in transferResult.Transfers)
                    {
                        Dts.Events.FireInformation(0, null,
                            string.Format("Upload of {0} succeeded", transfer.FileName),
                            null, 0, ref fireAgain);
 
                    }
                }
 
                Dts.TaskResult = (int)DTSExecResult.Success;
            }
            catch (Exception e)
            {
                Dts.Events.FireError(0, null,
                    string.Format("Error when using WinSCP to upload files: {0}", e),
                    null, 0);
 
                Dts.Log(string.Format("Error when using WinSCP to upload files: {0}", e), 1, emptyBytes);
 
                Dts.TaskResult = (int)DTSExecResult.Failure;
            }
        }
 
        #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
 
   }
}