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…