How to Load Data from An Excel File to SQL Server Table by using SSIS Package

In this video post you will learn how to load data from An Excel file from single sheet to SQL Server Table. When we load the data from An Excel file to SQL or any other Relational Database
Management System, we often encount Data Conversion Issues.
The video will teach you following topics

  1. How to Analyze the data of Excel File and Create Table in SQL ServerHow to create Excel Connection Manager to read the data from an Excel file
  2. How to find out Data Conversion Issues while loading Excel file and Fix Data Conversion issues by using Data Conversion Transformation.
  3. How Excel Read the First 8 rows or mislead with Data Types and how to read Alpha numeric values from Excel file 
  4. How to use IMEX=1 property in Excel Connection Manager property to Read Alpha Numeric values
  5. How to load data to SQL Server by using OLE DB Destination.


Load Data from An Excel File to SQL Server Table in SSIS Package