Import data from Multiple Excel File to SQL Server using an SQL Server Integration Services | part 6

Publicado em: 17 Abril 2022
no canal de: Syed Ali

2,424

Import data from Multiple Excel File to SQL Server using an SQL Server Integration Services (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 file with same field name with the same directory.

Example of multiple files in a directory: i.e. source file from where data will be transferred

Destination Table: where data will be saved.
CREATE TABLE [emp_attendance](
[empid] [int] NULL,
[emp_name] [nvarchar](255) NULL,
[Branch] [nvarchar](255) NULL,
[Attentance_date] [datetime] NULL,
[Status] [nvarchar](255) NULL
) ON [PRIMARY]

Some Step need to be followed to achieve this.
1) Add data flow task and then double click on it. And you will get the control flow task where you can add source and destination connection manager and configure it.
2) After configuration add for each loop container and then configure on its source file and directory
3) And also need to add two variables for excel file path and File Directory
4) and then run the application. Data will be transferred successfully.

Nesta página do site você pode assistir ao vídeo on-line Import data from Multiple Excel File to SQL Server using an SQL Server Integration Services | part 6 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Syed Ali 17 Abril 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 2,424 vezes e gostou 27 espectadores. Boa visualização!

10,891

110