Import data from multiple excel to multiple tables using SSIS:
Requirement:
1) SQL Server Data Tools for Visual Studio 2015
or
SQL Server Data Tools or Visual Studio 2019
2) and SQL Server instance
3) Multiple excel sheet.
For this we use conditional split component. Let us see the below example:
SSIS Conditional Split Transform task component is split data into multiple destinations based on the specified conditions.
CREATE TABLE [Employee_Delhi](
[empid] [int] NULL,
[emp_name] [nvarchar](255) NULL,
[emp_location] [nvarchar](255) NULL,
[salary] [float] NULL
) ON [PRIMARY]
Point to be Noted:
Now setting the expression of excel connection Manager so that in a folder all files will be available to import the data in SQL.
