Three decades of FTP protocol

How old is the FTP protocol? Its history started 44 years ago and the first specification of its current incarnation was published 35 years ago. However, this October marks the 30th anniversary of RFC 959, which remained the authoritative specification of the FTP protocol ever since. Over the years, it…

Using SFTP and FTP/SSL in SSIS package in VS 2012

SFTP and FTP/SSL components (included in Rebex File Transfer Pack) were not especially designed to run inside the SSIS (SQL Server Integration Services). However, with little effort component can be used from inside the SSIS "script task". The FTP/SSL component was chosen as a model for this sample…

How to upload data to FTP or SFTP server from a SQL-CLR procedure (SQL Server 2012 and VS 2012)

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 in the environment of SQL Server…

10 years of Rebex FTP!

Ten years ago, we released the first version of Rebex FTP. I wrote most of the core code myself and we all learned a lot during the process. Rebex was new in this field and we didn't quite know what to expect, so we were delighted when you, our customers,…

File modification date and time in FTP

Updated 16th Jul 2013:¬†added description for IIS 8.0. FTP protocol provides several ways to obtain a file's last modified date/time. The returned values may vary in time zone or time precision. This article discusses the technological background, describes a behavior of several common FTP servers and discusses…