SQL Server Integration Services (SSIS) -Send File using FTP Task in SSIS Package


In this article we are going to see how to use a FTP task in a SSIS package to Send a file. To follow my series of articles on SSIS packages refer to my profile for the links.


In this article we are going to see how to use a FTP task container in packaging. A FTP task is mainly used to do a file transfer using FTP. SSIS provides the in-built task container to do a FTP of a file. Let's jump start to see the how to use the task in real time. Here I'm going to show a small example of how to configure a FTP task and Send a file to the remote host. 

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see how to use FTP task container. Drag and drop the FTP task as shown in the screen below.

Now double-click on the task to open the property window and set the properties as shown in the screen below.

The above image is for setting the FTP Connection; the end user needs to provide the correct connection settings and click on the Test Connection to confirm if the connection is valid. 

Now in the file transfer tab we need to set the property since in our example we are going to send the file to FTP we need to set as below. Here input variable is used to get the path where we need to get the file.

Here the operation section we need to select Send Files in order to send files to a destination FTP. And in the Remote parameters section we need to specify the FTP site location using a variable and in the local parameter section we need to select the local file location to send a file to the remote location.

Once you have given valid credentials by running directly the package will do the necessary steps of sending the files from FTP to the local folder. 


So in this article we have seen on how to use the FTP task to send a file from a local to a remote site.


Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now