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 ...
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 ...
UPDATE: This blogpost from year 2009 uses old API (GetFiles method), in the new versions of Rebex components there are the newer multiple file operations Upload and Download. See the multiple-file operations feature page for code samples in C# and VB.NET. ...
If using SQL Server 2012 Data Tools for Visual Studio 2012, use an updated version of this blogpost. The SFTP and FTP/SSL component included in File Transfer Pack was not especially designed to run inside the SSIS (SQL Server Integration Services). ...
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 ...
