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

Scenario:

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. jaosnsmskthJune 16, 2021 at 8:17 PM

    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

    kodi.software

    ReplyDelete

Subscribe to: Post Comments (Atom)