SSIS Tutorial Part 28 - Archive Files with Datetime after Loading into SQL Server Table

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to load multiple files to SQL Server Table and then archive them to archive folder by adding date and time to them.

In this video you will learn following tasks/transformations

  1. How to create an SSIS Package
  2. How to use For-each Loop Container to read the files from folder in SSIS Package
  3. How to load multiple text files to SQL Server Table in SSIS Package
  4. How to use Data Flow Task in SSIS Package
  5. How to Flat File Source in SSIS Package to read text file
  6. How to use OLE DB Destination to load data to SQL Server Table in SSIS Package
  7. How to write expressions in SSIS Package
  8. How to use File System Task in SSIS Package
  9. How to rename and move file in SSIS Package 

Archive Files with Datetime after Loading into SQL Server Table - SQL Server Integration Services