How to Load Multiple Excel Files Data to SQL Data Table using SSIS Components [Live Example]

Published: 11 March 2021
on channel: Gurunatha D

10,694

203

In this video we will see how to extract data from multiple excel files or from bulk excel folder and load the same data to SQL Server Data Warehouse table using SSIS components .

So in this example we have extracted the data using excel source component and load bulk excel files using Foreach loop container and also we did transformation using Data Conversion, Derived Column, Conditional Split, UnionAll components and for loading purpose we use ADO.NET destination component.

For more videos : https://www.questpond.com

For more tutorials : https://www.onlinebuff.com

On this page of the site you can watch the video online How to Load Multiple Excel Files Data to SQL Data Table using SSIS Components [Live Example] with a duration of hours minute second in good quality, which was uploaded by the user Gurunatha D 11 March 2021, share the link with friends and acquaintances, this video has already been watched 10,694 times on youtube and it was liked by 203 viewers. Enjoy your viewing!

134,156

3.8K