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
hello sir I followed as on videos it gives me error.Error says error to load the ms access db engien cannot open to the file(folderpath)
ReplyDeletethis a error code:O*80004005,
would you help to fix those error
not only in this one any project related with excel shows error
hope to hear soon from you
ReplyDeleteReplace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx"
ReplyDeleteIN THIS LINE I DIDN'T GET WHAT IS THE ACTUAL MEAN "DT_WSTR,50"
We need to convert to string before concatenate
DeleteHow to extend the functionality of the program that excel files have different sheet names
ReplyDelete