HDTutorial
EN
SSIS Tutorial Part 19-How to Load Data from Excel File to SQL Server Table in SSIS Package

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SSIS Tutorial Part 19-How to Load Data from Excel File to SQL Server Table in SSIS Package

111,029 views October 25, 2015 14:17

Watch on YouTube
ChannelTechBrothersIT

Description from the creator

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

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
How to find out Data Conversion Issues while loading Excel file and Fix Data Conversion issues by using Data Conversion Transformation.
How Excel Read the First 8 rows or mislead with Data Types and how to read Alpha numeric values from Excel file
How to use IMEX=1 property in Excel Connection Manager property to Read Alpha Numeric values
How to load data to SQL Server by using OLE DB Destination.

To Follow Step by Step this SSIS video tutorial By Tech Brothers
techbrothersit.com/2014/12/ssis-videos.html

About this tutorial

TechBrothersIT published this 14:17 video tutorial on October 25, 2015. It has been watched 111,029 times on YouTube.

Duration
14:17
Published
October 25, 2015
Views
111,029
Likes
450

Tags

Share

Further reading

This tutorial in other languages