How to Upload Multiple Files from Local Folder to FTP Server by using FTP Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

Scenario:

We have multiple files sitting in one of our Local folder those we created every day by using an SSIS Package. Once the files are created, we want to upload them to FTP Server so our client can use them.What solution we have to upload those files from Local folder to FTP Server?

Solution:


FTP Task in SSIS Package is capable to upload the file from Local folder to FTP Server. In this video we will learn how we can make use of FTP Task to upload multiple files.

We will learn following Items
  1. How to create an SSIS Package from Basics
  2. How to use For-each Loop Container with File Enumerator to get files from Local folder
  3. How to Load all the files from Local folder to FTP Server Folder by using FTP Task
  4. How to use Variables in SSIS Package and use in FTP Task


How to Transfer Multiple Files from Local Folder to FTP Server by using FTP Task in SSIS Package



Related Posts / Videos on FTP Task / Script Task