SSIS Part 151-Load Data from Excel Files when Number of Columns can decrease in Excel Sheet/s
SSIS Real Time Scenario:
How to Load Data from Excel Files when Number of Columns can decrease or order is changed in Excel Sheet?
Let's say you are working for Auto Insurance Company as ETL developer, you get different excel files from different regional office those you need to load to Dbo.Customer Table in TechBrothersIT database.
Link to the script
http://www.techbrothersit.com/2016/03...
But you often face problem as you don't always get the exact columns.Sometime you get a nice excel file with Id,Name and Dob and often you get the file with only Name column and sometime you get the file with Id and name.
You might get Excel file with single sheet or multiple containing exact number of columns those we have in our destination sql server table.
But there are Excel sheets you are getting which does not have exact number of columns. You are getting less no of columns than your SQL server Columns.
We will cover below things in this video
How to load Data from Excel Files to SQL Server Table by using C#
How to Read Sheet Name from Excel File in SSIS Package
How to read Excel File Name in SSIS Package
How to Check matching Header Column Names to SQL Server Table by using C sharp
How to save scalar string value from SQL Server Query to Variable in C Sharp
How to use BulkCopy to load data from DataTable to SQL Server Table
How to Map Columns Dynamically in BulkCopy C Sharp
How to loop through Excel files and load them into a database using SSIS package?
How to import Excel files with different names and same schema into database?
On this page of the site you can watch the video online SSIS Part 151-Load Data from Excel Files when Number of Columns can decrease in Excel Sheet/s with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 14 March 2016, share the link with friends and acquaintances, this video has already been watched 14,624 times on youtube and it was liked by 68 viewers. Enjoy your viewing!
