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)

2021-04-15

4,128 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

SQL Server Kerberos authentication from a Linux clients

By Louis Lam-391748

Hi All, I have a need to establish a SQL Server Kerberos authentication from...

Housekeeping of SQL Azure DB's

By NicHopper

Hi all, I have a question for you, as some move into the cloud...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers