Scenario:
We have an agreement with one of our vendor that they will provide the file on daily basis to us. They agreed to upload a file to FTP Server. We need to build a process that can run on daily basis and download the file form FTP Server to our Local Server.Solution:
We can use FTP Task in SSIS Package to download the file/s from FTP Server to Local Folder. In this video we will perform a demo how FTP Task can be used for requirement. Items we will learn in this video
- How to create an SSIS Package from Basics
- How to connection to FTP Server by using Internet Explorer
- How to download a file from FTP Server by using FTP Task in SSIS Package
- How to use Variables in FTP task to change the Local Folder Path and Remote Path
- How to overwrite the file in Local Folder if already exists while downloading by FTP Task
Download a file by using FTP Task in SSIS Package
Related Posts / Videos on FTP Task / Script Task
- FTP Task - How to Upload Single File to FTP Server from Local Folder in SSIS Package
- FTP Task - How to Upload Multiple Files from Local Folder To FTP Server Folder in SSIS Package
- FTP Task - How to Download All the files from FTP Server Folder to Local Folder in SSIS Package
- FTP Task - Filter Files by using WildCard in FTP Task in SSIS Package for downloading
- FTP Task - Delete Specific Files or All Files from FTP Server Folder by using SSIS Package
- FTP Task - Download Only Current Day Files from FTP Server by using FTP Task in SSIS Package
- FTP Task - Create A Directory Folder For Each Day and Load Files on FTP Server by using SSIS Package
- Get File Names from FTP Server and Save to SQL Server Table in SSIS Package by using Script Task
- FTP Task and Script Task - How to Avoid FTP Task error when no file found on FTP Server
- FTP Task and Script Task - How to Delete Folder with Files from FTP Server by using SSIS Package
- FTP Task and Script Task - Download a File from FTP Site and Delete after Download in SSIS Package
- FTP Task and Script Task - Sync Local Folder to FTP Server Folder without Upload Existing Files by SSIS Package
- Sync FTP Folder to Local Folder without Downloading Existing Files by using Script Task in SSIS Package
- FTP Task/Script Task - Rename File on FTP Server After Downloading in SSIS Package
- FTP Task/Script Task -How to move file from one folder to another folder on FTP server by using SSIS Package
- FTP Task - Create Local Folder with Date on Daily basis and load files from FTP Folder in SSIS Package
- FTP Task - How to Save Password,User Name,Ftp Server Name as variables/Parameters in SSIS Package to make SSIS Package Dynamic to run in SIT, UAT, QA and Prod.
I feel SSIS is the most important and useful aspect and component of solving complex IT problems and looking for solutions.
ReplyDeleteSSIS Upsert