SQLServerCentral Article

Load Multiple Excel Files and Worksheets with SSIS

I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File2.xlsx, as shown here: Each Excel File has three […]

4.33 (3)

You rated this post out of 5. Change rating

2021-04-15

7,595 reads

Blogs

T-SQL Tuesday #181: A Technology Present

By

It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...

Trace Flag 3625 Follow Up

By

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

The Hash Join III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Hash Join III

Continuous Learning

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Continuous Learning

Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Virtualizing GCP data by using...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers