The video explain real time scenario in which we have multiple types of files sitting in a folder and we want to load only specific type of files by using SSIS Package.
In this video you will also learn
In this video you will also learn
- How to create an SSIS Package
- How to use Foreach Loop Container in SSIS Package
- How to read specific type of files by using Foreach Loop Container
- How to use Data Flow Task to load flat files into SQL Server Table
- How to write expressions in SSIS Package
Read Files as per Extension and Load them to a SQL Server Table in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial
Check out our other related posts/videos on Containers
- How To Load Files to Different Tables according to the File Name in SSIS Package
- How to load multiple Excel files to SQL Server Table and then archive them by adding date time to them?
- 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
Why same concept not working for the Excel files. I am getting new excel files every day and I need to dump the data from Excel to SQL Server, I tried so many solutions but all are giving errors for Connection string. I also tried to use the ExcelFilepath instead of Connection String but nothing working
ReplyDelete