using Rebex.Net;

Since Microsoft SQL Server 2005, stored procedures (and some other database objects) can be written externally in some .NET language, imported to the SQL database and called as stored procedures. The following sample demonstrates how to call Rebex FTP component from the T-SQL code. Methods of Rebex FTP API cannot be accessed from T-SQL directly ...

What’s common for FTP, POP3, IMAP, SMTP, HTTP? All those protocols share same method for encryption of communication between client and server – the TLS/SSL. TLS is just a new name for SSL version 3.1 (for details see KB article about Secure FTP). The TLS/SSL comes in two common flavors: TLS/SSL Explicit TLS/SSL Implicit What’s the ...

Quick & dirty (yet a bit naive) directory download code To download all files in a specified remote folder seems to be a trivial task at first. Calling Ftp.GetList(), iterating through the returned collection and caling Ftp.GetFile() on each item looks like a no brainer. It would work in simple cases. However, there are some caveats in this ...

The SFTP and FTP/SSL component included in File Transfer Pack was not especially designed to run inside the SSIS (SQL Server Integration Services). However, with little effort both components can be used from inside the SSIS ''script task''. Registering the component for use in IDE for SSIS packages Registering the component for use in normal ...

PowerShell - a powerful new scripting language and command shell from Microsoft - has many built-in commands. However, it lacks support for transferring files over FTP, FTP/SSL or SFTP. Luckily, PowerShell is based on .NET and can invoke methods of .NET classes. Let's see how to upload or download files to an FTP or SFTP server from a PowerShell ...