The CData SSIS Components for SFTP models SFTP data as an easy-to-use SQL database with tables and stored procedures. Any changes to the remote data are immediately reflected in your queries, and the table definitions are dynamically retrieved.

The component uses the SFTP API to process supported filters. The component processes other filters client-side within the component.

• The Tables section, which details standard SQL tables, contain samples of what you might have access to in your SFTP account.
• Stored Procedures are actions that are invoked via SQL queries. They perform tasks that extend beyond merely downloading, uploading files, and sending protocol commands to the server.