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

Scenario: 

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.

Solution:

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

@[User::LocalMainFolder]+Replace(Substring((DT_WSTR,30)GETDATE(),1,10),"-","")



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




Related Posts / Videos on FTP Task / Script Task

1 comment:

  1. hello
    how to create and sync remote folders and subfolders with local machine

    ReplyDelete