SSIS FTP Task Receive Files

In this article, we will show you the steps involved in configuring the SSIS FTP task to receive files with examples.

NOTE: The SSIS FTP Task uses the FTP Connection Manager to connect with the Remote (FTP Server) Files and Folders.

The below screenshot shows you the data inside the FTP Server. Our task is to Copy the Multicast.txt file present inside the Root directory to the File System Folder inside E Drive.

SSIS FTP TASK RECEIVE FILES Source

The following screenshot shows you the folders inside the local drive.

SSIS FTP TASK RECEIVE FILES 0

SSIS FTP TASK RECEIVE FILES

To receive files from the FTP Server to the local computer, First Drag and drop the FTP Task into the Control Flow region. And rename it as SSIS FTP Task Receive Files

SSIS FTP TASK RECEIVE FILES 1

Double-click on it will open the FTP Task Editor to configure it. Please change the task name as you need and provide a valid description.

SSIS FTP TASK RECEIVE FILES 2

Within the Connection section, click on the FTPConnection drop-down arrow shows the existing FTP Connections (If any). Or please click on the <New Connection..> option. Here, we use the already created Connection from the FTP Connection Manager article.

SSIS FTP TASK RECEIVE FILES 3

Please click on the File Transfer tab to configure the FTP operations. The following screenshot shows the available properties in this tab.

SSIS FTP TASK Receive Files 14

In this example, we want to receive a file from FTP Server. So, we select the Receive Files option from the Operations property.

SSIS FTP TASK RECEIVE FILES 4

For the time being, we are declaring the Remote path manually, but in real-time, use variables. Please click on the browse (…) button beside this option to open the remote directory.

SSIS FTP TASK RECEIVE FILES 5

From the below screenshot, you can see / as the location because it is the root directory of the FTP server, and currently, we don’t have any subfolders. Our task is to Copy the Multicast.txt file present inside the Root directory to the File System Folder inside E Drive. So, we are selecting the MULTICAST.txt file.

SSIS FTP TASK RECEIVE FILES 6

Here, we declared the Local path manually, but in real-time, we recommend variables. If we set the IsLocalPathVariable to False, configure the Source Connection using LocalPath Property. If you have already created the File Connection Manager, select it from the drop-down list. Otherwise, create it by selecting <New Connection..>.

SSIS FTP TASK RECEIVE FILES 7

Once you select the <New Connection..> for files and folders, the File Connection Manager Editor will open. We have to configure the connection with the existing folder using this editor. To do so, please click the Browse button to select the Existing Folder from the file system.

SSIS FTP TASK RECEIVE FILES 8

From the below screenshot, we selected the FILE SYSTEM TASK – COPY FILES Folder as the local folder path. Click the OK button to select it.

SSIS FTP TASK RECEIVE FILES 9

OverwriteDetination: If we set this property to true, the SSIS FTP Task overwrites the existing folder (if any) in the Destination path.

SSIS FTP TASK RECEIVE FILES 10

Click OK to finish configuring the SSIS FTP task receive files package. Let’s run and see whether we successfully Copied the Multicast.txt file from the FTP Server to the local File System or Not.

SSIS FTP TASK RECEIVE FILES 11

We successfully Copied the Multicast.txt file from the FTP Server to the File System Task – Copy files Folder.

SSIS FTP TASK RECEIVE FILES 12