{"id":2981,"date":"2018-03-12T21:45:40","date_gmt":"2018-03-12T21:45:40","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2981"},"modified":"2019-04-06T07:58:13","modified_gmt":"2019-04-06T07:58:13","slug":"ssis-sftp-task-examples-upload-download-move-delete-files-folders","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/","title":{"rendered":"SSIS SFTP task examples to upload, download, move and delete files \/ folders"},"content":{"rendered":"<h2>Introduction &#8211; Using SSIS SFTP task (FTP, SFTP, FTPS)<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full alignleft\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/sftp-task\/ssis-sftp-ftp-ftps-task.png\" width=\"128\" height=\"128\" \/>In this article, we will show <strong>SSIS SFTP task examples<\/strong>. This task supports multiple protocols (Classic FTP, SFTP, FTPS).<\/p>\n<p>Uploading files using SFTP or downloading files are common requirements in SSIS. In order to work with FTP, Microsoft SSIS includes the FTP Task that allows to upload files to FTP, download files, creating local and remote directories an more. However, there is no native task to work with SFTP. Also Native FTP task doesn&#8217;t support many advanced options such as FTP over SSL (i.e. FTPS).\u00a0 In this article, we will show how to use the <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-sftp-task-ftp-ftps\/\" target=\"_blank\" rel=\"noopener\">SSIS SFTP task<\/a> included in ZappySys <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a>.<\/p>\n<p>ZappySys SFTP Task will let you send files to SFTP\/FTP\/FTPS server, receive files from SFTP\/FTP\/FTPS server. With ZappySys SFTP Task, you can not only create\/delete files and folders on ftp server but also get file properties (creation date, last modified, last read dates, size and more), verify if the files exist, rename and move files and more.<\/p>\n<h2><\/h2>\n<h2>SSIS SFTP Task Video Tutorial<\/h2>\n<p>The following video shows a nice tutorial about a ZappySys SSIS SFTP Task with examples:<\/p>\n<div class=\"su-youtube su-u-responsive-media-yes\"><iframe loading=\"lazy\" width=\"600\" height=\"400\" src=\"https:\/\/www.youtube.com\/embed\/qZfA3OpnlAw?\" frameborder=\"0\" allowfullscreen allow=\"autoplay; encrypted-media; picture-in-picture\" title=\"\"><\/iframe><\/div>\n<h2>Requirements<\/h2>\n<ol>\n<li>First, you will need to have SSIS installed<\/li>\n<li>Also, make sure to have SSDT<\/li>\n<li>Finally, do not forget to install\u00a0ZappySys <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a><\/li>\n<\/ol>\n<h2>Whats is FTP, FTPS, SFTP, FTP\/SSL?<\/h2>\n<p>Many people still have confusion over various protocols around FTP terminology. Most common terms you hear are as below.<\/p>\n<ul>\n<li>FTP<\/li>\n<li>Classic FTP<\/li>\n<li>Secure FTP<\/li>\n<li>SFTP<\/li>\n<li>FTPS<\/li>\n<li>FTP\/SSL<\/li>\n<li>FTP over SSL<\/li>\n<li>FTP Over SSH<\/li>\n<\/ul>\n<p>You must be overwhelmed by now \ud83d\ude42 &#8230; So are they all same or different? See below for quick clarification in nutshell.<\/p>\n<p>Mainly there are 2 protocols for FTP and yes they are very different but still used to do Files Transfer to \/ from remote server.<\/p>\n<ol>\n<li><strong>Classic FTP<\/strong>\u00a0&#8211; sometimes referred as just <strong>FTP<\/strong> (Typically server runs on Port 21)<\/li>\n<li><strong>SFTP<\/strong> &#8211; Sometimes referred as <strong>Secure FTP<\/strong> or <strong>FTP over SSH<\/strong> (Typically server runs on Port 22)<\/li>\n<\/ol>\n<p>So in short SFTP is not same as Classic FTP protocol. SFTP is more secure because traffic is always encrypted. On the other hand Classic FTP is not encrypted by default but you can use <strong>FTP over SSL<\/strong> to request encrypted traffic in classic FTP. <strong>FTP over SSL<\/strong> also referred as <strong>FTPS or FTP\/SSL<\/strong>.<\/p>\n<h2>Getting Started<\/h2>\n<p>In order to start, we will show several examples. ZappySys includes an SSIS SFTP task that will allow to work with SFTP, FTP or even FTPS. Let\u00b4s start with an example. In this SSIS SFTP task example, we will show how to download files from SFTP to local folders.<\/p>\n<ol>\n<li>First, in a new SSIS project, drag and drop the\u00a0<strong>ZS Secure FTP Task.\u00a0<\/strong>This task will let you send and receive files in FTP:\n<div id=\"attachment_2986\" style=\"width: 696px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2986\" class=\"size-full wp-image-2986\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\" alt=\"Drag and drop FTPS task\" width=\"686\" height=\"386\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png 686w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task-300x169.png 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><p id=\"caption-attachment-2986\" class=\"wp-caption-text\">Using SSIS SFTP Task in the control Flow Designer<\/p><\/div><\/li>\n<li>Secondly, double click the\u00a0<strong>ZS Secure FTP Task <\/strong>and select the\u00a0<strong>Download FTP server file(s) to local directory.\u00a0<\/strong>This option will download files. In Path AccessMode we can use\u00a0<strong>Direct\u00a0<\/strong>to write the path directly or to use an SSIS variable. In path, you can use &#8220;<strong>\/ &#8221;\u00a0<\/strong>to specify the root folder <strong>\/source\u00a0<\/strong>would be a folder named source in the root. If there were another folder inside source named child1, the path would be <strong>\/source\/child1<\/strong>.\u00a0 There is a nice option that you can check to include folders and child folders. If you need to include them, check the option\u00a0<strong>Recursive scan.\u00a0<\/strong>In target, the tab can be written directly (<strong>direct)<\/strong>\u00a0and using SSIS variables. The variables will be explained later. In path you specify the path of the target. You can throw an exception if there is a need to overwrite files and folders. Finally, in Connection, press <strong>New<\/strong> button to create a new connection:\n<div id=\"attachment_2987\" style=\"width: 692px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/zappysys-source-ssis-sftp-send-files.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2987\" class=\"size-full wp-image-2987\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/zappysys-source-ssis-sftp-send-files.png\" alt=\"Download ftps files\" width=\"682\" height=\"611\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/zappysys-source-ssis-sftp-send-files.png 682w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/zappysys-source-ssis-sftp-send-files-300x269.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><p id=\"caption-attachment-2987\" class=\"wp-caption-text\">SSIS Secure FTP Task &#8211; Download files from FTP \/ SFTP Server<\/p><\/div><\/li>\n<li>The following options are available in SSIS Secure FTP Task:\n<div id=\"attachment_3026\" style=\"width: 690px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/storage-action-ssis-ftps-task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3026\" class=\"size-full wp-image-3026\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/storage-action-ssis-ftps-task.png\" alt=\"SSIS upload and download actions\" width=\"680\" height=\"474\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/storage-action-ssis-ftps-task.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/storage-action-ssis-ftps-task-300x209.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-3026\" class=\"wp-caption-text\">Option to upload, download files in SSIS<\/p><\/div><\/li>\n<li>You can also overwrite files and folder, skip all, overwrite if source is older, overwrite if the file size is different, rename files and more:\n<div id=\"attachment_3027\" style=\"width: 689px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/overwrite-action-ssis-ftps-task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3027\" class=\"size-full wp-image-3027\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/overwrite-action-ssis-ftps-task.png\" alt=\"Option to overwrite files in SSIS FTPS\" width=\"679\" height=\"590\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/overwrite-action-ssis-ftps-task.png 679w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/overwrite-action-ssis-ftps-task-300x261.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><p id=\"caption-attachment-3027\" class=\"wp-caption-text\">Overwrite files in SSIS<\/p><\/div><\/li>\n<\/ol>\n<h3>Configuring the SSIS SFTP Connection Manager<\/h3>\n<p>In this new section, we will show how to configure the Connection Manager. We configure before the Secure FTP task, and we pressed the New button to create a new connection.<\/p>\n<ol>\n<li>In the connection manager for SFTP, we will work with the SFTP Connection Manager. We will choose if the protocol is FTP, FTPS or SFTP. Also, we need to specify the host. In this example, we are using a localhost, but in other cases, you will need to specify the IP. By default, the<strong> SFTP<\/strong> port is <strong>22<\/strong>. If it is a different port in your case, specify the port, otherwise leave blank. The <strong>FTP<\/strong> default port is <strong>21<\/strong> and FTPS<strong> 990<\/strong>.\u00a0 If you have multiple files, make sure to check the option\u00a0<strong>Retain the same connection.<\/strong>\n<div id=\"attachment_2984\" style=\"width: 670px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sftp-user-pwd-ssis.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2984\" class=\"wp-image-2984 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sftp-user-pwd-ssis.png\" alt=\"SSIS FTP Task\" width=\"660\" height=\"617\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sftp-user-pwd-ssis.png 660w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sftp-user-pwd-ssis-300x280.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/a><p id=\"caption-attachment-2984\" class=\"wp-caption-text\">SSIS SFTP Connection manager (Support for Classic FTP, SFTP, FTPS (i.e. FTP \/ SSL))<\/p><\/div><\/li>\n<li>There are different types of <strong>Logon Types<\/strong>. A username and a password is the most common way to login, but you can also use other types like the\u00a0Public\/private key authentication,\u00a0X509 certificate authentication, KerversosV5 user\/password\/domain,\u00a0NTLM single sign-on (GSSAPI) and\u00a0NTLM user\/password\/domain (GSSAPI).\n<div id=\"attachment_3028\" style=\"width: 668px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/logon-type-supported-ssis-ftps.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3028\" class=\"size-full wp-image-3028\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/logon-type-supported-ssis-ftps.png\" alt=\"Logon types supported\" width=\"658\" height=\"557\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/logon-type-supported-ssis-ftps.png 658w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/logon-type-supported-ssis-ftps-300x254.png 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/a><p id=\"caption-attachment-3028\" class=\"wp-caption-text\">SFTP Connection Manager &#8211; Logon types (i.e. Username\/password, Public \/ Private Key, NTLM )<\/p><\/div><\/li>\n<li>If everything is OK, it will copy all the files from the SFTP in the source folder in the\u00a0C:\\destination folder.<\/li>\n<\/ol>\n<h3>Working with advanced filters<\/h3>\n<p>In order to understand filters, we will create an example for you. This time we will create SSIS SFTP task example to show how to exclude some files from the downloading process.<\/p>\n<ol>\n<li>In addition, it is also possible to add advanced filters to the SSIS SFTP task to exclude or include files and folders. The following example shows how to use the Advanced filters. In the\u00a0<strong>Secure FTP Task,\u00a0<\/strong>go to the Advanced Filter page and in Exclude RegX we will write \\.exe$ to exclude the file with exe extension to be downloaded. You can use RegX (regular expressions) in the advanced filter:\n<div id=\"attachment_3037\" style=\"width: 693px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/working-with-advanced-filters.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3037\" class=\"size-full wp-image-3037\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/working-with-advanced-filters.png\" alt=\"Advanced filters\" width=\"683\" height=\"591\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/working-with-advanced-filters.png 683w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/working-with-advanced-filters-300x260.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><p id=\"caption-attachment-3037\" class=\"wp-caption-text\">Advanced filters FTP<\/p><\/div><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3>Working with wildcards in\u00a0SSIS SFTP task (Multiple files)<\/h3>\n<p>In order to understand wildcards, the new example will show how to work with Wildcards will help you to work with multiple files or folder with common characteristics.<\/p>\n<ol>\n<li>The following example shows how to copy all the files will all the extensions in the source folder. We use the *.*, which means that any file name with any extension will be downloaded:\n<div id=\"attachment_2992\" style=\"width: 691px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sfpt-connection-manager-ssis.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2992\" class=\"size-full wp-image-2992\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sfpt-connection-manager-ssis.png\" alt=\"SSIS FPTS connection\" width=\"681\" height=\"590\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sfpt-connection-manager-ssis.png 681w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/sfpt-connection-manager-ssis-300x260.png 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/a><p id=\"caption-attachment-2992\" class=\"wp-caption-text\">SSIS SFTP connection manager<\/p><\/div><\/li>\n<li>If we want to download all the files with extension txt, use the following Path:\n<pre class=\"lang:amigados highlight:0 decode:true\">\/source\/*.txt;<\/pre>\n<\/li>\n<li>Another example would be to download all the files with the following names: file1.txt, file2.txt and file3.txt.\u00a0 We could use the following Path:\n<pre class=\"lang:default highlight:0 decode:true\">\/source\/file?.txt<\/pre>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3><strong>Working with SSIS expressions and variables in SFTP \/ FTPS to delete FTP files<\/strong><\/h3>\n<p>In order to understand expressions, the following example will show how to work with SSIS expressions combined with variables in the SSIS SFTP task. In this example we will delete files in SFTP using variables and expressions.<\/p>\n<div id=\"shellMainStage\" class=\"shell mainStage\">\n<div id=\"chatServiceContainer\" class=\"shell main\">\n<div class=\"chatContainer\">\n<div id=\"chatComponent\" class=\"chatComponentContainer swx showFocusRing\" dir=\"ltr\">\n<div id=\"swxContent1\" class=\"swxContent\">\n<div class=\"fragmentsContainer hideContent\">\n<div class=\"fragment\">\n<div class=\"conversationControl chat themeLight allowTextSelection\">\n<div class=\"conversation scrollable scrollViewport scrollViewportV\">\n<div class=\"history scrollViewport-inner\">\n<div class=\"scroller\">\n<div class=\"messageHistory largeAllowed visible\" role=\"list\">\n<div class=\"bubble\">\n<div id=\"msg_15748596827534091469\" class=\"content\">\n<div class=\"messageTextWrapper\">\n<p class=\"urlPreviewText\">ZappySys Providers simple and powerful Placeholders. You can still use SSIS expression language. Placeholders allow direct Variable Use easy to see compared to hidden SSIS Expression (C# style). Placeholders have simple embedding use of variables.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\u00a0First, we will first create a variable in SSIS. In the SSIS Project, go to the menu and select SSIS and variables. Create a variable with the Data type string and specify a Value. In this example the file name is <strong>MyFile<\/strong> and the Value<strong> file1<\/strong>.\n<div id=\"attachment_2994\" style=\"width: 782px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2994\" class=\"size-full wp-image-2994\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png\" alt=\"Create a SSIS variable\" width=\"772\" height=\"205\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png 772w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable-300x80.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable-768x204.png 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/a><p id=\"caption-attachment-2994\" class=\"wp-caption-text\">Create an SSIS variable<\/p><\/div><\/li>\n<li>As a second step, we will write in path the value<strong>\u00a0\\destination\\{{User.MyFile}}.txt.\u00a0<\/strong>This will concatenate the folder destination with the variable MyFile. The task will delete the file1.txt from the SFTP folder.\n<div id=\"attachment_2995\" style=\"width: 690px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-expressions-task-ftp.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2995\" class=\"size-full wp-image-2995\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-expressions-task-ftp.png\" alt=\"Add a SSIS expression\" width=\"680\" height=\"591\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-expressions-task-ftp.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-expressions-task-ftp-300x261.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-2995\" class=\"wp-caption-text\">Create SSIS expressions<\/p><\/div><\/li>\n<li>The next example will show how to create a SFTP file using expressions and variables in SSIS:\n<div id=\"attachment_3034\" style=\"width: 690px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftps-expressions-task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3034\" class=\"size-full wp-image-3034\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftps-expressions-task.png\" alt=\"Create ftps file\" width=\"680\" height=\"588\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftps-expressions-task.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftps-expressions-task-300x259.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-3034\" class=\"wp-caption-text\">Create file ftp<\/p><\/div><\/li>\n<li>Content to write is the content of the file. In\u00a0<strong>Target,\u00a0<\/strong>go to path and write the following: For more information on placeholders <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-format-specifiers.htm#A1\" target=\"_blank\" rel=\"noopener\">check this post<\/a>\u00a0and also check <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/115004918633-How-to-format-Path-URL-using-date-time-format\" target=\"_blank\" rel=\"noopener\">this post<\/a>.\n<pre class=\"lang:amigados highlight:0 decode:true\">\/destination\/{{User::FileName,MM-dd-yyyy}}<\/pre>\n<\/li>\n<li>We are using a variable in SSIS named FileName of type DateTime. We are concatenating the SFTP folder destination with the variable. As you can see, the expressions with ZappySys are very simple.<\/li>\n<\/ol>\n<h3>Example working with variables in the SSIS FTP Task to upload files<\/h3>\n<p>In order to understand variables, this example about SSIS TASKS FOR SFTP will show how to work with variables. We will specify the path in a variable.<\/p>\n<ol>\n<li>In this example, we will create a variable with a path. The Data type will be string and the Value will contain the path:\n<div id=\"attachment_2996\" style=\"width: 781px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-working-with-variables.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2996\" class=\"size-full wp-image-2996\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-working-with-variables.png\" alt=\"Values in variables\" width=\"771\" height=\"206\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-working-with-variables.png 771w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-working-with-variables-300x80.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-working-with-variables-768x205.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/a><p id=\"caption-attachment-2996\" class=\"wp-caption-text\">SSIS variable values<\/p><\/div><\/li>\n<li>\u00a0Secondly, we will go to Path AccessMode, we will select Variable and select the variable in Path variable:\n<div id=\"attachment_2997\" style=\"width: 699px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-upload-file-sftp-variable.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2997\" class=\"size-full wp-image-2997\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-upload-file-sftp-variable.png\" alt=\"Send files SFTP\" width=\"689\" height=\"593\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-upload-file-sftp-variable.png 689w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-upload-file-sftp-variable-300x258.png 300w\" sizes=\"(max-width: 689px) 100vw, 689px\" \/><\/a><p id=\"caption-attachment-2997\" class=\"wp-caption-text\">ssis upload files SFTP<\/p><\/div><\/li>\n<\/ol>\n<h3>Working with variables to create a file in FTP<\/h3>\n<p>In order to understand the use of variables, will show how to create a file in SFTP. In this new SSIS SFTP task example, we will create a new file using variables.<\/p>\n<ol>\n<li>First, we will create an SSIS variable named Content that will store the file content. Create a variable of type String and write some text in it.<\/li>\n<li>Secondly, in AccessMode, select Content Variable and select <strong>Create new FTP<\/strong> <strong>file.\u00a0\u00a0<\/strong>In target\u00a0<strong>path,\u00a0<\/strong>you need to specify the file name that will be created. Next, select the User::Content variable to add content to the file:\n<div id=\"attachment_3000\" style=\"width: 692px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-sftp-create-file.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3000\" class=\"size-full wp-image-3000\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-sftp-create-file.png\" alt=\"SSIS FTPS task example\" width=\"682\" height=\"593\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-sftp-create-file.png 682w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-sftp-create-file-300x261.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><p id=\"caption-attachment-3000\" class=\"wp-caption-text\">Example for SSIS SFTP task<\/p><\/div><\/li>\n<\/ol>\n<h3>Example to verify if file exists in SSIS SFTP task<\/h3>\n<p>Finally, we will verify if a file in SFTP exists or not using the SSIS SFTP task. The new SSIS SFTP task example will show how to work with variables and another useful ZappySys task used to get values of variables.<\/p>\n<ol>\n<li>In order to start, we will use the SSIS variables, create a variable of type string named FileExists. In\u00a0<strong>Storage Action,\u00a0<\/strong>select\u00a0<strong>Get FTP file exist status.\u00a0<\/strong>In path, select the path of the file to verify if it exists or not.\n<div id=\"attachment_3007\" style=\"width: 689px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-ftp-file-exists.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3007\" class=\"wp-image-3007 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-ftp-file-exists.png\" alt=\"SSIS SFTP task example to check if file exists\" width=\"679\" height=\"588\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-ftp-file-exists.png 679w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-task-ftp-file-exists-300x260.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><p id=\"caption-attachment-3007\" class=\"wp-caption-text\">Verify if file exists in SFTP<\/p><\/div><\/li>\n<li>Secondly, we will use the\u00a0<strong>ZS Logging Task\u00a0<\/strong>to check the value of the variable File Exists. This task will show the value of the variable in the log. Drag and drop the task and join it with the ZS Secure FTP Task:\n<div id=\"attachment_3006\" style=\"width: 745px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-log-task.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3006\" class=\"size-full wp-image-3006\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-log-task.png\" alt=\"ZappySys log task\" width=\"735\" height=\"484\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-log-task.png 735w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-log-task-300x198.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/a><p id=\"caption-attachment-3006\" class=\"wp-caption-text\">The SSIS Log task<\/p><\/div><\/li>\n<li>In order to get the value, we will insert it in the Logging Task. To do that, insert the Variable and select the FileExists variable:\n<div id=\"attachment_3005\" style=\"width: 634px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3005\" class=\"size-full wp-image-3005\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png\" alt=\"Configuring variable\" width=\"624\" height=\"501\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png 624w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists-300x241.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><p id=\"caption-attachment-3005\" class=\"wp-caption-text\">Add the variable in the task logging<\/p><\/div><\/li>\n<li>Finally, run the package and verify the Output (you can use View and Output to see the output) and check the value of the Logging Task. If the file exists, the value will be true. If it does not exist, the value will be false.\n<div id=\"attachment_3004\" style=\"width: 1036px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3004\" class=\"size-full wp-image-3004\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png\" alt=\"Verify the value of the variable in the SSIS output\" width=\"1026\" height=\"234\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png 1026w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-300x68.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-768x175.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-1024x234.png 1024w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><\/a><p id=\"caption-attachment-3004\" class=\"wp-caption-text\">Verify the variable in Output<\/p><\/div><\/li>\n<\/ol>\n<h2>How to loop through SFTP \/ FTP files in SSIS<\/h2>\n<p>You can also loop through files to perform custom action file by by. SFTP Task support Action to <strong>get File List as ADO.net Recordset<\/strong><\/p>\n<p>To get File list from FTP Server perform the following steps.<\/p>\n<ol>\n<li>Download and Install SSIS PowerPack <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/download\/\" target=\"_blank\" rel=\"noopener\">from here<\/a><\/li>\n<li>Open Visual Studio and Create New SSIS Project.<\/li>\n<li>In the SSIS control flow designer drag &amp; drop <strong>ZS Secure FTP Task<\/strong><\/li>\n<li>Double click to configure SSIS SFTP Task.<\/li>\n<li>From Storage Action select <strong><strong>Get FTP files as ADO.net DataTable<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_3055\" style=\"width: 903px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-loop-secure-ftp-sftp-files.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3055\" class=\"size-full wp-image-3055\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-loop-secure-ftp-sftp-files.png\" alt=\"SSIS SFTP Task - Loop through Files \/ Folders stored on FTP Server\" width=\"893\" height=\"480\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-loop-secure-ftp-sftp-files.png 893w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-loop-secure-ftp-sftp-files-300x161.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-loop-secure-ftp-sftp-files-768x413.png 768w\" sizes=\"(max-width: 893px) 100vw, 893px\" \/><\/a><p id=\"caption-attachment-3055\" class=\"wp-caption-text\">SSIS SFTP Task &#8211; Loop through Files \/ Folders stored on FTP Server<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/li>\n<li>Create new FTP Connection by clicking New next to connection dropdown.<\/li>\n<li>Select Source Path (e.g\u00a0 <strong>\\myroot\\folder\\*.txt\u00a0<\/strong> )<\/li>\n<li>Select or create new SSIS Variable (e.g. <strong>varFiles<\/strong> ) which will hold file list result (Must be Object datatype variable).<\/li>\n<li>Click OK to close.<\/li>\n<li>Create 3 more SSIS variables to hold File Path (String), Name (String) and Size (Int32). We will use in the next step.<\/li>\n<li>Now drag SSIS ForEach Loop Container Task from SSIS Toolbox<\/li>\n<li>Edit Loop Task and Select <strong>Foreach ADO Enumerator<\/strong> from the Enumerator dropdown<\/li>\n<li>Select variable (e.g.\u00a0<strong><strong>varFiles)<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_346\" style=\"width: 635px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-346\" class=\"wp-image-346 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png\" alt=\"Loop through files in SSIS using ForEach Loop Task (use ADO.net Recordset variable)\" width=\"625\" height=\"563\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png 625w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-300x270.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-346\" class=\"wp-caption-text\">Loop through files in SSIS using ForEach Loop Task (use ADO.net Recordset variable)<\/p><\/div><\/li>\n<li>Click on Variable Mappings Tab and configure like below.\n<div id=\"attachment_345\" style=\"width: 582px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-345\" class=\"size-full wp-image-345\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png\" alt=\"Variable Mappings for ForEach Loop Task - Loop through files in a folder using SSIS\" width=\"572\" height=\"272\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png 572w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping-300x143.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/a><p id=\"caption-attachment-345\" class=\"wp-caption-text\">Variable Mappings for ForEach Loop Task &#8211; Loop through files in a folder using SSIS<\/p><\/div><\/li>\n<li>Drag ZS Logging Task and place inside Loop and Display variables<\/li>\n<li>Thats<\/li>\n<\/ol>\n<p>For more information to <a href=\"\/\/zappysys.com\/blog\/get-list-of-files-and-folders-in-ssis-for-looping\/\" target=\"_blank\" rel=\"noopener\">loop through files on local machine using SSIS check this article<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>Algorithms \/ Ciphers supported by Secure FTP Task<\/h2>\n<p>Secure FTP Task comes with many option to tweak many aspects about security so you can turn on and off algorithms used by components.<\/p>\n<p><a href=\"https:\/\/zappysys.com\/forums\/topic\/ciphers-algorithms-supported-sftp-connection\/\" target=\"_blank\" rel=\"noopener\">Click here to learn more<\/a> about supported Ciphers \/ Macs and Encryption Algorithms used by SSIS SFTP Task.<\/p>\n<h2>Conclusion<\/h2>\n<p>To conclude, we can say that working with SFTP is now very simple. In this article, we looked at SSIS SFTP task examples\u00a0on how to upload, download, delete files and folders. We used variables, wildcards and expressions. If you liked the tasks you can start using them by downloading SSIS PowerPack from our <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">web site here<\/a>. We saw different SSIS SFTP task examples to understand how to use the task in different scenarios.<\/p>\n<p>Thanks for your time.<\/p>\n<h2>References<\/h2>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">About SSIS PowerPack<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/expressions\/integration-services-ssis-expressions\">Integration Services (SSIS) Expressions<\/a><\/li>\n<\/ul>\n<p>Keywords:\u00a0SSIS SFTP task example,upload SFTP files, download SFTP files.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction &#8211; Using SSIS SFTP task (FTP, SFTP, FTPS) In this article, we will show SSIS SFTP task examples. This task supports multiple protocols (Classic FTP, SFTP, FTPS). Uploading files using SFTP or downloading files are common requirements in SSIS. In order to work with FTP, Microsoft SSIS includes the FTP Task that allows to [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":2986,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[138],"tags":[296,295,294,12,291],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS SFTP task example to upload, delete and download files \/ folders<\/title>\r\n<meta name=\"description\" content=\"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS SFTP task example to upload, delete and download files \/ folders\" \/>\r\n<meta property=\"og:description\" content=\"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-03-12T21:45:40+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-04-06T07:58:13+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"686\" \/>\r\n\t<meta property=\"og:image:height\" content=\"386\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/\",\"name\":\"SSIS SFTP task example to upload, delete and download files \/ folders\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\",\"datePublished\":\"2018-03-12T21:45:40+00:00\",\"dateModified\":\"2019-04-06T07:58:13+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png\",\"width\":686,\"height\":386,\"caption\":\"FTPS SSIS Task\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS SFTP task examples to upload, download, move and delete files \/ folders\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/hshah\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS SFTP task example to upload, delete and download files \/ folders","description":"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/","og_locale":"en_US","og_type":"article","og_title":"SSIS SFTP task example to upload, delete and download files \/ folders","og_description":"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.","og_url":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/","og_site_name":"ZappySys Blog","article_published_time":"2018-03-12T21:45:40+00:00","article_modified_time":"2019-04-06T07:58:13+00:00","og_image":[{"width":686,"height":386,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/","url":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/","name":"SSIS SFTP task example to upload, delete and download files \/ folders","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png","datePublished":"2018-03-12T21:45:40+00:00","dateModified":"2019-04-06T07:58:13+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"In this article, we will show a SSIS SFTP task example to send and receive files and also work with variables, wilcards and expressions using ZappySys.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ZappySys-FTP-SSIS-Task.png","width":686,"height":386,"caption":"FTPS SSIS Task"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-sftp-task-examples-upload-download-move-delete-files-folders\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS SFTP task examples to upload, download, move and delete files \/ folders"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","caption":"ZappySys"},"url":"https:\/\/zappysys.com\/blog\/author\/hshah\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2981"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=2981"}],"version-history":[{"count":45,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2981\/revisions"}],"predecessor-version":[{"id":6694,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2981\/revisions\/6694"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2986"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}