SSIS FTP Task Receive Multiple Files

In this article, we will show you the steps involved in configuring the SSIS FTP task to receive multiple files with examples. Please refer to the FTP Task Receive Files to understand the configuration settings involved in receiving a single file from the FTP Server to the local file system.

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

The below screenshot shows the data inside the FTP Server. Our task is to Copy all the files (.txt, .xls, .jpg) present inside the Root directory to the File System Folder inside E Drive.

SSIS FTP Task Receive Multiple Files Source

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 0

SSIS FTP Task Receive Multiple 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 Multiple Files

SSIS FTP TASK RECEIVE MULTIPLE FILES 1

Double click on it will open the FTP Task Editor to configure it. Please change the task name and description.

SSIS FTP TASK RECEIVE MULTIPLE FILES 2

Within the Connection section, click on the drop-down arrow beside the FTPConnection show the previously created FTP Connections (If any). Or click on the <New Connection..> option to create one. In this example, we use the already created Connection from the FTP Connection Manager article.

SSIS FTP TASK RECEIVE MULTIPLE FILES 3

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 14

The SSIS FTP task supports eight different operations on Files and Folders. In this example, we want to receive multiple files from FTP Server. So, We are selecting the Receive Files option from the Operations property.

SSIS FTP TASK RECEIVE MULTIPLE FILES 15

If you’re going to choose a single file manually, please click on the browse (…) button beside this option to open the remote directory. In this example, we want to send all files (irrespective of extensions) from the FTP server to the local file system. So, we use Wildcard.

TIP: If you want to send only text files, then use: /*.txt

SSIS FTP TASK RECEIVE MULTIPLE FILES 4

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 5

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 9

From the below image, you can observe that 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 MULTIPLE FILES 10

OverwriteDetination: If we set the property to true, the SSIS FTP Task overwrites the existing files in the Destination path.

SSIS FTP TASK RECEIVE MULTIPLE FILES 6

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 7

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

SSIS FTP TASK RECEIVE MULTIPLE FILES 8

Comments are closed.