On several occasions I have had to use SSIS to export data from a SQL database, and then transfer that data to a third party via sFTP. SQL Server SSIS has an FTP task built in but it does not natively support sFTP. There are several commercial products (Eldos Software, /n Software, CozyRoc) out on the market [...]
Posts Tagged ‘sFTP’
Using sFTP in SQL Server SSIS
Posted in SQL Server, tagged sFTP, SQL Server, SSIS on February 23, 2012 | Leave a Comment »
