SSIS SFTP Task (Secure FTP, FTPS)

SSIS SFTP Task Examples – send and receive multiple files (upload, download, loop, create, rename, move files and folders)

SSIS SFTP Connection Manager – Configure FTP / SFTP / FTPS Credentials (Host, Port, Username, Password, Key file and more)

SSIS SFTP Task supports many operations such as Download FTP server files to local directory, Upload local files to FTP server, Delete FTP files, Delete FTP folder(s), Move FTP files, Rename FTP files, Create new FTP file, Create new FTP folder, Create new FTP folder if does not exist, Get FTP files size, Get FTP file exist status, Get FTP files count, Get FTP file Last Modified Date, Get FTP file CreationDate, Get FTP file LastAccessDate (Last Read), Read FTP File content as text, Read FTP File content as byte array, Get FTP folder exist status, Get FTP file list as ADO.net DataTable, Get FTP folder list as ADO.net DataTable

SSIS SFTP Task – Example of Receive multiple files from FTP. You can download multiple files from remote FTP server using simple wildcard pattern (e.g. *.txt) or use advanced search pattern using regex / regular expression criteria) to exclude or include certain files.

SSIS SFTP Task – Example of Receive multiple files from FTP. You can download multiple files from remote FTP server using simple wildcard pattern (e.g. *.txt) or use advanced search pattern using regex / regular expression criteria) to exclude or include certain files.

SSIS SFTP Task – Include/exclude files from local or remote file search using regex (regular expression)

SSIS SFTP Task supports Delete multiple files from FTP Server. You can also use wildcard or regex pattern to include or exclude certain files from delete operation.

SSIS SFTP Task supports create file/folder operation. You can also use SSIS Variable to make things dynamic. Use variable placeholder anywhere in the File Path or Content without worrying about complex expression.

SSIS SFTP Task support Get File List as ADO.net Recordset operation. This option will produce ADO.net data table with following columns. You can loop through ADO.net recordset using ForEachLoop Task. Below is the list of columns and ordinal 0 => Path [DataType=System.String] 1 => Name [DataType=System.String] 2 => Size [DataType=System.Int64] 3 => LastWriteTime [DataType=System.DateTime] 4 => LastAccessTime [DataType=System.DateTime] 5 => CreationTime [DataType=System.DateTime]