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
Expression used for video to get date_time.
Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx"
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.
Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx"
Load Multiple Excel Files to SQL Server Table & Archive them with Date-time - 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 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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.