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.