SSIS Tutorial Part 101-Download a File from FTP Server and Delete after Download in SSIS Package

FTP Task/Script Task in SSIS Scenario:

In this video we will learn how to download a file from FTP Server Folder to Local Folder and then delete from the FTP Server Folder.

Items we will learn this video
How to create SSIS Package from Scratch
How to Create FTP Connection
How to create variables to save Local Path, Remote Path and FileName
How to use variables in Script Task to Download the file and then Delete after download if file exists
How to use FTP Connection in Script Task in SSIS Package

Link to the blog post for this video with script
http://sqlage.blogspot.com/2015/05/how-to-download-file-from-ftp-site-and.html

source

by TechBrothersIT

linux ftp server