Utilizing SFTP within SSIS

http://insights.iolap.com/author/cware/

Chris Ware is a Principal Consultant at iOLAP, Inc., with a focus on ETL. He began his career providing analysis support and reporting in marketing and then insurance for a major retailer. Chris has had the opportunity to work within many different verticals throughout his data warehousing career using a variety of different integration tools. He feels that because data integration is ever changing that the opportunity to employ new processes is endless.

View all author posts →

Within SSIS a FTP task exists which enables you to access a FTP server. However, it does not support Secure FTP (SFTP). There are many Secure FTP tools to choose from and each requires a unique set of commands and designs to be used within SSIS.

For this article, I am using Putty.org’s file transfer tool commonly known as PSFTP (a free open source tool). This tool performed as needed and we were able to build additional processes around it to enhance its use and satisfy our customers’ requirements.

To download the article, please click here: Utilizing SFTP Within SSIS

ETL