Create A Directory( Folder) For Each Day and Load Files on FTP Server by using SSIS Package - SQL Server Integration Services(SSIS) Tutorial


We have a requirement in which we need to run our SSIS Package at the end of the day and It should create a new directory on FTP Site with Date and then upload all the files from Local folder to newly created directory.

What we will learn in this video
  1. How to create an SSIS Package from basics
  2. How to create Directory with Date on FTP Server
  3. How to upload files from Load folder to newly created directory with Date
  4. How to write Expressions on Variable in SSIS Package
  5. How to use FTP task in SSIS Package

Create Directory with Date on FTP Server and Upload Files to it in SSIS Package

Related Posts / Videos on FTP Task / Script Task

1 comment:

  1. Thanks for sharing the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too