Create Directory with Date on Local Path & download Files from FTP Server by using SSIS Package - SQL Server Integration Services(SSIS) Tutorial


We have to download the files from given FTP Server Folder to our local folder. But on daily basis we want to create a folder with Date and then download the files to it.


Here are the things we will learn in this video
  1. How to create an SSIS Package from Scratch
  2. How to Create Variable and write expression on it to evaluate to current date
  3. Use in File System Task to Create Directory with Date if not exits
  4. Use the FTP Task to download all the files to newly created Directory on Local Folder

Expression used for LocalFullFolderPath Variable to build folder path with Date in SSIS Package


 Create Date Directory and Download Files from FTP Server in SSIS Package

Related Posts / Videos on FTP Task / Script Task