SSIS Tutorial Part 25-Load Multiple Excel Files to SQL Server Table & Archive them with Datetime

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

  1. How to load Multiple Excel files to SQL Server Table
  2. How to Load Multiple Excel files to SQL Server Table and Archive with date-time added to them.
  3. How to use For-each Loop Container
  4. How to use Excel Source in SSIS
  5. 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"


5 comments:

  1. UnknownJune 3, 2020 at 4:53 PM

    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)
    this a error code:O*80004005,
    would you help to fix those error
    not only in this one any project related with excel shows error

    ReplyDelete
  2. UnknownJune 3, 2020 at 4:54 PM

    hope to hear soon from you

    ReplyDelete
  3. Yam BasnetJuly 7, 2020 at 9:29 AM

    Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".xlsx"
    IN THIS LINE I DIDN'T GET WHAT IS THE ACTUAL MEAN "DT_WSTR,50"

    ReplyDelete
    Replies
    1. HarshaAugust 3, 2021 at 1:00 AM

      We need to convert to string before concatenate

      Delete
  4. StyranyAugust 5, 2021 at 1:56 AM

    How to extend the functionality of the program that excel files have different sheet names

    ReplyDelete

Subscribe to: Post Comments (Atom)