In this video you will learn
- How to load Multiple Excel files to SQL Server Table
- How to Load Multiple Excel files to SQL Server Table and Archive with date-time added to them.
- How to use For-each Loop Container
- How to use Excel Source in SSIS
- How to use File System Task to rename and move files.
Expression used for video to get date_time.
- How to Read Files according to Extension and Load them to a SQL Server Table in SSIS Package
- How To Load Files to Different Tables according to the File Name in SSIS Package
- How to Execute Multiple dot SQL files by using SSIS Package
- How to Extract file names from Folders and save in SQL Server Table by using SSIS Package
- How to Archive files with Date-time after loading into SQL Server Table in SSIS Package
- How to Create Multiple Files from a SQL Server Table in SSIS Package