In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to load the files according to the file names in SQL Server Tables.
The video covers real time scenario and requirement where we often have to extract the file name from given file name with date-time and load to table as per file name.
This video also covers
The video covers real time scenario and requirement where we often have to extract the file name from given file name with date-time and load to table as per file name.
This video also covers
- How to create SSIS Package from Scratch
- How to use For-each Loop Container in SSIS Package
- How to use Precedence Constraints in SSIS Package
- How to write expressions in Precedence Constraint in SSIS Package
- How to use Data Flow Task in SSIS Package
- How to Write Expressions on Connection Managers in SSIS Package
- How to use Flat File Source in SSIS Package
- How to use OLE DB Destination in SSIS Package
Load Files to Different Tables according to the File Name in SSIS Package - SQL Server Integration Services ( SSIS ) Tutorial
Check out our other related posts/videos on Containers
- How to Read Files according to Extension and Load them to a SQL Server Table 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
At the end of the video you had mentioned about scripting to load hundred of files, can you post how to do that please?
ReplyDeleteAamir sir.. Can You please provide me teh code which has been used in SCRIT TASK
ReplyDeleteHello Sir. Please share the link where we can find a solution to load 100 of different files in sql table
ReplyDelete