Example #1
0
        static void setUpFileTransfer(Rebex.Net.Sftp ftpClient, string site, string user, string password)
        {
            Console.WriteLine("Connecting to Host: {0}", site);

            ftpClient.Connect(site);
            ftpClient.Login(user, password);
        }
Example #2
0
 public int setUpFileTransfer(Rebex.Net.Sftp ftpClient, string site, string user, string password)
 {
     try
     {
         ftpClient.Connect(site);
         ftpClient.Login(user, password);
     }
     catch (SftpException ex)
     {
         Console.WriteLine("Login failed: {0}  {1}", ex.Message, ex.Status);
         return(9);
     }
     Console.WriteLine("Login success; connected to host: {0}", site);
     return(0);
 }
Example #3
0
        public override DTSExecResult Execute(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents,
                                              IDTSLogging log, object transaction)
        {
            try
            {
                using (var sftp = new Rebex.Net.Sftp())
                {
                    // connect to a server
                    sftp.Connect(HostName, ServerPort);
                    // authenticate
                    sftp.Login(LoginId, Password);

                    //sftp.Encoding = Encoding.ASCII;//.BigEndianUnicode;//.ASCII;//.Unicode;
                    sftp.TransferType = TransferType;

                    if (FtpType == FtpType.Download) //read from MFT
                    {
                        var filesToRead = sftp.GetList(InBoundFolderPath)
                                          .Where(fl => fl.Name.StartsWith(SourceFileNamePattern, StringComparison.OrdinalIgnoreCase))
                                          .Select(s => new
                        {
                            FileName     = s.Name,
                            FullFilePath = InBoundFolderPath + "/" + s.Name
                        }).ToArray();

                        if (filesToRead.Any())
                        {
                            var _downloadedFileNames = new List <string>();

                            //download the file into local folder
                            foreach (var file in filesToRead)
                            {
                                sftp.GetFiles(file.FullFilePath, LocalPath,
                                              SftpBatchTransferOptions.Default, SftpActionOnExistingFiles.OverwriteAll);
                                _downloadedFileNames.Add(file.FileName);

                                if (ReWriteFileToASCII)
                                {
                                    string from = Path.Combine(LocalPath, file.FileName);
                                    string to   = Path.Combine(LocalPath, file.FileName + "_temp");
                                    using (StreamReader reader = new StreamReader(from, System.Text.Encoding.UTF8, true, 10))
                                        using (StreamWriter writer = new StreamWriter(to, false, System.Text.Encoding.ASCII, 10))
                                        {
                                            while (reader.Peek() >= 0)
                                            {
                                                writer.WriteLine(reader.ReadLine());
                                            }
                                        }
                                    //delete old file and rename *_temp file to old file
                                    File.Delete(from);
                                    File.Move(Path.Combine(LocalPath, file.FileName + "_temp"), Path.Combine(LocalPath, file.FileName));
                                }

                                //delete the file, after download
                                if (DeleteSourceFileOnSuccess)
                                {
                                    sftp.DeleteFile(file.FullFilePath);
                                }
                            }
                            DownloadedFileNames = string.Join(",", _downloadedFileNames);
                        }
                        else
                        {
                            throw new Exception(string.Format("No file with name pattern:'{0}' found inside folder :'{1}' to download.", SourceFileNamePattern, InBoundFolderPath));
                        }
                    }
                    else //outbound -> write to MFT
                    {
                        //get file from application path
                        var filesToWrite = Directory.GetFiles(LocalPath, SourceFileNamePattern + "*");

                        if (filesToWrite.Any())
                        {
                            //upload file
                            foreach (var file in filesToWrite)
                            {
                                sftp.PutFiles(file, OutBoundFolderPath, SftpBatchTransferOptions.Default);

                                //delete the file, after upload
                                if (DeleteSourceFileOnSuccess)
                                {
                                    File.Delete(file);
                                }
                            }
                        }
                        else
                        {
                            throw new Exception(string.Format("No file with name pattern:'{0}' found inside folder :'{1}' to upload.", SourceFileNamePattern, LocalPath));
                        }
                    }
                    sftp.Disconnect();
                }
                return(DTSExecResult.Success);
            }
            catch (System.Exception e)
            {
                componentEvents.FireError(0, null, string.Format("Error using Rebex Sftp: {0}", e), null, 0);

                return(DTSExecResult.Failure);
            }
        }