SSIS Tutorial Part 25-Load Multiple Excel Files to SQL Server Table & Archive them with Datetime

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to load Multiple Excel files to a SQL server Table and archive them after loading them.


In this video you will learn

  1. How to load Multiple Excel files to SQL Server Table
  2. How to Load Multiple Excel files to SQL Server Table and Archive with date-time added to them.
  3. How to use For-each Loop Container
  4. How to use Excel Source in SSIS
  5. How to use File System Task to rename and move files.



Expression used for video to get date_time.
Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx"