Pasan's Blog

  In this blog post, I am going to show you how to import an excel file data into the database table using SQL Server Integration Services .  Below is shown the sample excel file. Step 01: - First, we need to create a new database in the SQL Server. After that, we need to create a new table in the designed database structure to store excel file data. Step 02: - Create a new SSIS package for import the excel file data into the SQL Server table. Step 03: - Drag and drop the Data Flow Task into the Control Flow as shown below. Step 04: - Drag and drop the Excel Source into the Data Flow as shown below. Step 05: - We need to create a new excel connection manager. So, right-click on the connection manager window and select the New Connection. Step 06: - Select the connection manager type as Excel and click on the Add button. Step 07: - Configure the Excel connection manager by providing the excel file path. Then Excel Version is automatically selected. If your source excel file sh...