SSIS Tutorial Part 90- How to Upload Single File to FTP Server from Local Folder in SSIS Package

SSIS Video Scenario:

Every day at 5:00 PM our company create a file that we need to share with our Clients. The way we want to share this file with our client is by using FTP Server. We need to create an SSIS Package that can read the file from our local folder and upload to the FTP Server. If file exists on FTP Server already , we want to overwrite it.


Solution:

In this video we will learn how to use TFP Task to upload a file from our local folder to FTP Server.

we will learn following items in this video



How to create an SSIS Package from scratch
How to create variables in SSIS Package and use them in FTP Task
How to use FTP Task to read from Local folder and upload to FTP Server
How to Create FTP Connection and avoid errors while creating it
How to overwrite file at destination if exists by using FTP Task




Link to the blog post for this video
sqlage.blogspot.com/2015/05/how-to-upload-singl…

Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
techbrothersit.com/2014/12/ssis-videos.html