Import data from excel into SQL Server using SSIS

[@ganeshasarasati1930]

Thanks for all your lessons always.Just want to add one information.If while loading the data, the data type gives issues then keeping a sample row in the template file and hiding that row in the excel helps.This video is on creating the template dynamically and it is very useful to see the example.

[@ganeshasarasati1930]

There was a video in one of the posting of yours i think which explained on loading using a template. The hiding column does not help but C# scripting helps basically for data type issues.

[@DevartSoftware]

You may already use Excel add-in for SQL Server for that purpose www.devart.com/excel-addins/sql-server.html or this SSIS component www.devart.com/ssis/

[@jonasfurtado4057]

Thanks so much Keshav for sharing your knowledge...

[@krismaly]

Thanks for educating the community

[@abrammakgalemele3491]

Tx Keshav. You are the best!

[@srinivassurpur4144]

really very nice information. it helps lot to me....

[@NaziraLala]

Hi Keshav.. This was a very good and helpful video. Can you tell me how to see the installation from the beginning.

[@Makakamela]

thank you very much.good video. i have a question: what if a source file is .csv or xml format?

[@gtvweb590]

I'm big fan of your videos , they are no nonsense and straight to the point. In fact I would admit the fact I'm learning Sql server seeing your videos. At work we have multiple servers and I need to generate the disk space report on daily basis. I was manually going to each server and see the space and putting back in excel. is there any way i can automate the process.

[@shaikhirfan123456789]

Hi Keshav, I would really appreciate if you can tell me the sequence to watch the SSIS series. waiting for your reply. thank you.

[@maruasibanda3736]

+irfan shaikh same here man. thanks in advance

[@hritikaojha9960]

can you please explain what happens when we again run this package?

[@trinhk]

Nice work, but this only works if you have similar schema on the Excel file. I have a situation where I want to load the Excel file dynamically, and the excel file have different columns or even worksheet name. Any idea how I could approach this? I believe there's no way to modify the meta data (specifically the mapping) in the data flow.

[@Trendiebug]

Hi keshav. .. I am struck at some point in ssis pkg where i have to dump excel data to db... in my db I have int column and I am getting null from excel (excel may be string). I tried data conversion but getting error... could you please help me out

[@nusjaboy]

hi i have a question on how the system should validate the excel data, if the data in the database is already exists? thanks!

[@kevasp]

What's happen if column in A excel different with B excel sheet? would you load dynamic column in tables?

[@excelhelp1]

Hi, I want a c# code that would import the excel file into sql and create the table at run time based on the excel sheet. Any ideas? I have an excel workbook with a several sheets each having atleast 10 columns. I want to import them all to sql, creating the tables at run time, execute a stored procedure on them and export them back to a new excel workbook. Your help would be really appreciated!

[@srinivassurpur4144]

I want to know how to import the text file into sql db with SSIS... please share the information

[@MrAbidbd]

Great job!! very helpful tutorial

[@erickalonso5402]

Thanks Keshav, excellent video.

[@KeshavSingh83]

@sanvedlop Thanks !

[@subheesh1000]

How do we can appy this on xlsx file . can you give the link

[@gates1978]

Guys, where can I have the files for this tutorial. the excel file

[@brenonbarros2636]

11 anos atrás!!

[@kiranthentu]

Hi Keshav, nice blog with good explanation, very help full thank you. Could you please explain, I would like to know, data load from SQL Server table to multiple spread sheets in same excel file, based on condition. this should be done by dynamically and I don't want to create Excel file in prior, it should get created while package running. Example: my table contains some 1000's of records, from those records I would like to dump all IT department records into Sheet1, HR department records into Sheet2, Finance department to Sheet3 and Operations department to Sheet4 in the same Excel file In the same way multiple spread sheets from single excel file to SQL server table. I don't know how many spread sheets in excel file. Example: A Excel file contains 10 spread sheets, I would like to get all these 10 spread sheets data into single table by union all. Please help me. Please share a video for above example. Thanks in advance

[@solorefsnes2038]

Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel to sql convert esy es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.

[@devtaubayev]

Thanks, helpful video.

[@sanvedlop]

wonderful job there!

[@nnietocs]

Very useful. Thanks.

[@johanhernansanchezvillano5212]

excellent work helped me

[@jdgamboa5201]

Hi, thank you sooooo, so much for your series, they're gonna be saving my ass for the close future. And now, can you please show us how make a remote connection to a Windows server with a sql server instace installed? Thank you.

[@Princesshuba]

how can i save my excel document in els file

[@dkoothan360]

guys i have csv excel file , i need to change the xls file . Please help me guys if you know

[@satyamtek]

good concept

[@qqaadir]

good work

[@SheherYar]

Hi , Could you please record some Tutorials in Hindi/Urdu for millions of students they want in their own language. but they are struggling to find any good quality tutorials of SQL Server. Please Kindly upload some SQL Server and BI Tutorials in Hind or Urdu. many thanks.........................Sheher

[@Trendiebug]

Hi keshav. .. I am struck at some point in ssis pkg where i have to dump excel data to db... in my db I have int column and I am getting null from excel (excel may be string). I tried data conversion but getting error... could you please help me out